Home MS SQL Server DB Maintenance Manage SQL Server Memory allocation
Manage SQL Server Memory allocation E-mail
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