High memory utilization by sqlservr.exe process

Posted by abdul samad on Server Fault See other posts from Server Fault or by abdul samad
Published on 2011-06-14T06:47:46Z Indexed on 2014/08/19 16:22 UTC
Read the original article Hit count: 257

Filed under:

memory-usage

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

Related posts about memory-usage

SQL Server 2005 high memory usage and performance problems

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there guys. I have this ASP.NET/SQLServer2005 website running on a production server (Win2003, QuadCore, 4GB). The site runs smoothly normally, but after 2-3 weeks I notice a slow performance on the site (especifically in one particular page). Also I notice that the SQL Server process is using… >>> More
Coldfusion on VPS, how much JVM heap memory?

as seen on Server Fault - Search for 'Server Fault'
Recently I got a VPS server and I'm running Coldfusion, the website was running fine until it got more and more traffic and I started to encounter 'OutOfMemory' exceptions. I thought simply to rise the memory of the VPS server, but this didn't help. After doing some Google searches I found a setting… >>> More
Design approach, string table data, variables, stl memory usage

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an old structure class like this: typedef vector<vector<string>> VARTYPE_T; which works as a single variable. This variable can hold from one value over a list to data like a table. Most values are long,double, string or double [3] for coordinates (x,y,z). I just convert them as… >>> More
Normal memory usage in Rails

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm wondering how much memory usage is normal for a ruby process in a rails application? I really need something to benchmark against. In my dev environment WEBrick a single ruby process uses about 61mb to handle 10 simultaneous requests going non stop. In my prod environment Apache2+Passenger starts… >>> More
C++ memory usage

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi. I have pointer str: char * str = new char[10]; I'm using this memory for store data. How can I allocate more bytes for str and don't lost old data from str? >>> More

Developer IT