Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2012-06-20 : 10:26:14
|
| Hi Experts,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.Thank you in advance. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-20 : 10:40:59
|
| 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. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-06-20 : 11:49:02
|
| Check the sys.dm_os_memory_clerks DMV . From a diagnostic perspective , components with a noticeable memory consumption are assigned a memory clerk.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Memory Utilization