|
Manage SQL Server Memory allocation |
|
|
Written by Administrator
|
|
Wednesday, 01 April 2009 13:41 |
|
Setting SQL Server to use 59gb. This script will change SQL Server memory allocation. SQL Server has to be rebooted. EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE GO EXEC sys.sp_configure N'min server memory (MB)', N'60416' GO EXEC sys.sp_configure N'max server memory (MB)', N'60416' GO RECONFIGURE WITH OVERRIDE GO EXEC sys.sp_configure N'show advanced options', N'0' RECONFIGURE WITH OVERRIDE GO
|
|
Last Updated on Wednesday, 01 April 2009 13:45 |