Solved

Task manager shown sql server.exe with 22GB of memory???

Posted on 2008-06-25
5
925 Views
Last Modified: 2012-08-13
Hi,
I wonder why sqlservr.exe in task manager can us up to 22GB of memory, what wrong with my sql memory utilization? I'm running sql server 64 bit and one thing that I realize is page lock memory as not been configured yet.
sqlmemory.bmp
0
Comment
Question by:motioneye
5 Comments
 
LVL 7

Accepted Solution

by:
Christopher Martinez earned 500 total points
ID: 21871575
This, unfortunately, is a common problem.
What you need to do is limit the amount of memory MSDE is allowed to use.

First, you need to open taskmanager, make sure you're on the process tab, select View > Select Columns. Make sure 'PID (Processor Identifier)' is selected. Now check the exact PID and open a command prompt and type 'tasklist /svc'. Look for the PID and find which is taking the memory.

From there, you can use the link below to ascertain how to limit the memory, using the osql command and connecting to the database.

http://support.microsoft.com/?id=909636

ISA tends to take alot of memory. In my case i had issues with sbsmonitoring. I did this.

C:\>osql -E -S SERVER\sbsmonitoring
 sp_configure 'show advanced options',1
 reconfigure with override
 go
Configuration option 'show advanced options' changed from 0 to 1. Run the
RECONFIGURE statement to install.
 sp_configure 'max server memory',70
 reconfigure with override
 go
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
Configuration option 'max server memory (MB)' changed  to 70.
Run the RECONFIGURE statement to install.


Instead of 'Server' usre the name of your server and instead of sbsmonitoring use the PID your having issues with.
0
 

Author Comment

by:motioneye
ID: 21871637
Hi there is no reason for me to limit my memory, we do need more memory in this server to run, but I confuse why sqlserver.exe getting more memory, basically sqlserver.exe should and always consume little memory which just enough to boot the program and other memory will use by buffer pool which is internal to sql server
0
 
LVL 3

Expert Comment

by:JayeshKitukale
ID: 21871812
The TaskManager shows the memory consumed by:
1. The sqlservr.exe "code"
2. The "dynamic memory" allocated by SQL server to buffer the records and other data

So, the task manager does NOT JUST show the memory required to boot the program, but also the memory consumed while running (which is what you call buffer pool internal to sql server). Its the TOTAL memory consumed by the process which is quite large because the server might be fetching records and also buffering some of it for later use.
0
 
LVL 1

Expert Comment

by:pcguy-za
ID: 21895797
I found the article mentioned by Bahoopie very useful.  Note that MS say the sqlservr will continue to take memory on the off-chance that it may need it - but will release it if another process needs it.

I was able to set a maximum level using the method in the article - except that there is a problem in the syntx of the final command.  I used Bahoopies step-by step to input the command into osql.

motioneye - if your sqlservr is grabbing 22Gig - how much RAM does the server actually have?
0
 

Author Comment

by:motioneye
ID: 21905611
Hi,
Our server has 32Gb of RAM which running with 64 bit edition of windows + sql, but what make me feel weird why in task manager it show me 22GB??? I have plenty of servers which running with big memory and only this server showing very huge memory used in task manager, others are only <1GB but internally sql consumed around the same amount too > 22GB
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now