How to reconfigure SQL Server to utilize more server memory?

Context

We have upgraded our SQL Server VM's number of core and RAM memory. So we want to reconfigure SQL Server to make use of the additional memory.

Reconfigure using T-SQL

--change sql server configuration to utilize more memory.
EXEC sys.sp_configure N'max server memory (MB)', N'100000'
GO
RECONFIGURE WITH OVERRIDE
GO

Reconfigure using SSMS GUI

  1. Right click on the SQL Server from Object Explorer and select Properties then select Memory page on the left navigation.

  2. Update Maximum server memory (in MB)

  3. Click Ok

Last updated