Solved

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

Posted on 2008-06-25
5
954 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 express 24 44
Sql Server group by 10 57
SQL Server Configuration Manager WMI Error 11 54
SQL DATE Past due to current wek 4 22
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

734 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