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 |
Martyn123
Starting Member
29 Posts |
Posted - 2011-06-14 : 01:19:29
|
Sub:High memory utilization by sqlservr.exe process. When I look into task manager -->processes or by using perfmon memory counters(Sqlserver:memory manager:Target server memory and Total server memory)I am getting high memory utilization by sqlservr.exe process nearly 8 GB (Target server memory counter) and 7.95 GB (Total server memory). and when I restart the MSSQLSERVER service it again shoots up to the same size. I am getting this issue quite frequently. Please help me out in identifying why sql server is using so much memory and how to find out what query , stored procedure etc is making sql server use that much memory. *** I am not using any triggers or cursors in my code.Thanks |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-14 : 02:06:53
|
That's totally expected and not a problem. SQL is a memory hog and will use all it is allowed to (max server memory setting) to cache data and query plans.--Gail ShawSQL Server MVP |
 |
|
|
|
|