December 18, 2012 at 4:15 pm
There is high memory pressure in SQL Server 2008 R2. Memory available on server is 6 GB. Initially SQL Server max memory was set to the default value:2147483647. The memory usage was close to 6 GB. So, changed the SQL Server max memory to 4 GB. On checking task manager, I could see that SQL Server could use around 1.2 GB memory only but again total memory usage is still high. Can't find any other application apart from SQL Server on server. But from resource monitor, I can see high values for : commit(KB), Working Set(KB), Shareable(KB), Private(KB). What is the relation between each of these values in memory terms: commit(KB), Working Set(KB), Shareable(KB), Private(KB). Does SQL Server memory usage include the sum of all these individual values. I am not able to figure out.
Also, is there any way to figure out what is causing this high memory usage. This is 64 bit OS.
M&M
December 18, 2012 at 4:27 pm
Don't use Task Manager to check SQL's memory. It reports incorrect values.
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply