Optimal SQL Server max memory setting

It is very important to set the Max Server memory setting for SQL Server instance. Default setting allows SQL Server to use as much as memory available on the server. In a busier system, SQL Server might consume all the memory from the server. OS will be starving for memory to do normal operations. This kind of scenario highly impacts the system performance, so it is a best practise to strict SQL Server to consume only a fix amount of memory for its buffer pool not all.

Now the question comes, how much memory should we set for SQL Server?

There are many debates on this topic. However, considering some best case scenarios, there is a formula to calculate the same.

Note: Default is 2147483647 MB

Prasad Sahoo

Prasad Sahoo, is an enthusiast of Microsoft technologies in general and a passionate database professional, mainly focusing on SQL Server performance tuning and business intelligence. He has contributed a long time of his career working on SQL Server and other RDBMS. If he is not busy with SQL stuff then he must be watching some Hollywood movies.

Leave a Reply

%d bloggers like this: