BUS7 Consulting

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