Common SQL Server Mishaps
SQL Performance
JUNE 21, 2019
Prior to SQL Server 2012, the maximum server memory value only applied to the bufferpool, so customers needed to limit the amount of memory the bufferpool could use to save memory for the operating system and other processes. I tend to recommend increasing this value to a higher number after examining the Plan Cache.
Let's personalize your content