Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
    
Normal behavior. –  KCotreau Jun 14 '11 at 13:32

1 Answer 1

In my experience, SQL Server will attempt to preallocate as much memory as it can, as it is highly reliant on memory for performance. It usually takes our SQL Server machines about a week to get up to 32GB RAM footprint for the SQL Server process.

share|improve this answer
    
Specifically, unless you configure it to use less, SQL Server will try and use all the server's memory for cache (and therefore be faster). –  Richard Jun 14 '11 at 7:45

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.