This question already has an answer here:
- Memory Usage of SQL Server 2 answers
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.