Solved

sqlserver.exe usage of mamory and hard disk

Posted on 2007-03-23
3
1,485 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
Comment Utility
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

The SBS 2011 release date (RTM) is supposed to be around Christmas, 2011.  This article is a compilation of my notes -- things I have learned first hand.  The items are in a rather random order, but I think this list covers most of what is new and d…
The problem of the system drive in SBS 2003 getting full continues to be an issue, even though SBS 2008 and SBS 2011 are both in the market place.  There are several solutions to this, including adding additional drive space or using third party uti…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
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…

771 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

10 Experts available now in Live!

Get 1:1 Help Now