Solved

sqlserver.exe usage of mamory and hard disk

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
In the modern office, employees tend to move around the workplace a lot more freely. Conferences, collaborative groups, flexible seating and working from home require a new level of mobility. Technology has not only changed the behavior and the expe…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

864 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

24 Experts available now in Live!

Get 1:1 Help Now