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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 High memory utilization by sqlservr.exe process

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 Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -