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
Reconfigure using SSMS GUI
Right click on the SQL Server from
Object Explorer
and selectProperties
then selectMemory
page on the left navigation.Update
Maximum server memory (in MB)
Click
Ok
PreviousForeign key constraint with nocheckNextHow to find list of tables that does not contain a specific column in SQL Server
Last updated