Solved

sqlserver.exe usage of mamory and hard disk

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SBS 2011 6 51
Replacing a server/domain controller 5 121
Windows Server Backup - behind the scenes management algorithm 8 104
Excel 2013 Issues 11 56
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
More and more people are using the enhanced small form-factor pluggable (SFP+) tranceivers, and speed is of utmost importance. Testing of speeds are critical to ensure that the devices will meet the speed requirements. There are some testing challen…

679 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