Solved

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

Posted on 2008-06-25
5
915 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
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 video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 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

17 Experts available now in Live!

Get 1:1 Help Now