In one of my servers the sql server is utilizing the ram memory for about 22GB out of 30GB. And the allocated memory for the sql server is 20GB, Please let me know how to find that which is using this memory and how to rectify this problem. My Sql server 2008 with SP1 64bit is on windows 2008R2 64bit. I have checked in the task manager in that i can see SQLServr.exe is utilizing 17GB.I monitored in Activity monitor to find the blocking or locks but i couldnt find one. There are no slow running queries.
How do you know sql server is using 22GB if the task manager says it is using 17GB. What does task manager say about the rest of the memory?
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
Memory Utilization
Posted - 06/20/2012 : 10:26:14
