forked from ConfigMgrHydration/Setup
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSet-HYDSQLServerMemory.sql
More file actions
24 lines (19 loc) · 853 Bytes
/
Set-HYDSQLServerMemory.sql
File metadata and controls
24 lines (19 loc) · 853 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
/************************************************************************************************************************
Created: 2015-03-01
Version: 1.1
Homepage: http://deploymentfundamentals.com
Disclaimer:
This script is provided "AS IS" with no warranties, confers no rights and
is not supported by the authors or DeploymentArtist.
Author - Johan Arwidmark
Twitter: @jarwidmark
Blog : http://deploymentresearch.com
************************************************************************************************************************/
EXEC sp_configure 'show advanced options', '1'
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'max server memory', '12288'
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'min server memory', '8192'
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'show advanced options', '0'
RECONFIGURE WITH OVERRIDE