July 7, 2014 at 9:56 am
Hi there - I have set the max memory setting in SQL to use only 12GB however in the task manage it states that SQLSevr.exe is using 13.5GB. Why is this? Is it the fact that when setting the max memory you are setting how much data resides in memory?
Thanks!
--------------------------------------------
Laughing in the face of contention...
July 7, 2014 at 10:08 am
Max server memory sets the size of the buffer pool. SQL can and does use a small amount of non-buffer memory in addition to that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2014 at 10:23 am
Ok, thanks. As the data cache forms part of the buffer pool does this mean that setting the max memory does not strictly manage data but also the sql engine? Thanks!
--------------------------------------------
Laughing in the face of contention...
July 7, 2014 at 2:30 pm
It's several caches including plan cache and data cache.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2014 at 5:49 pm
arrjay (7/7/2014)
Hi there - I have set the max memory setting in SQL to use only 12GB however in the task manage it states that SQLSevr.exe is using 13.5GB. Why is this? Is it the fact that when setting the max memory you are setting how much data resides in memory?Thanks!
Don't forget to use perfmon and monitor your available bytes counter when you are changing MAX Memory, a setting or more than 100mb is recommended, if its consistently below 100MB you may have to look at either adding more memory or trimming back that max memory setting or looking at what other processes are consuming memory on your server.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply