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
Solved

sqlserver.exe usage of mamory and hard disk

Posted on 2007-03-23
3
1,489 Views
Last Modified: 2013-11-10
A lot of the server memory is being used more and more each day. When I investigate it sqlservr.exe is using a lot of memory and there are multiple instances of it. Every few days I have to start and stop the sqlservr.exe process in order to refresh the resources.
0
Comment
Question by:GerMelvin
3 Comments
 
LVL 15

Accepted Solution

by:
MarkMichael earned 250 total points
ID: 18779132
This, unfortunately, is a common problem.
What you need to do is limit the amount of memory MSDE is allowed to hog to around 100MB, max.
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 the exact instance of MSDE that is whoring 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

In my case, it was 'sbsmonitoring' consuming large amounts. If you have ISA installed, I've seen that eat mega memory. Here's an example of what I did:

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


You'd need to change 'SERVER' to the name of your own server and substitute 'sbsmonitoring' for whatever PID you identified previously.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

System overheating may become a serious problem if not taken care of at the proper time. I am writing this article because I faced a similar problem. Intro All electronic devices produce heat, but computers are a special case - the processors bo…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

829 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