Solved

SBS 2003 sqlservr.exe service memory keeps building!

Posted on 2006-06-26
6
583 Views
Last Modified: 2008-01-09
I'm having issues with my SBS 2003 sqlservr.exe service. There are 2 of these services running and 1 of them keeps building or holding memory. It gets to a point where I start recieving critical alerts. I go in and stop and restart the service to release the memory. I have to do this about every 3 or 4 days. Does anyone have any suggestions on why this keeps building up memory?
0
Comment
Question by:MikeASchreiner
  • 3
  • 2
6 Comments
 
LVL 13

Expert Comment

by:itcoza
ID: 16983788
Hi MikeASchreiner,

If you go to the services MMC. There should be more than one SQL service (server) running there. Once you have the problem again, you can restart any one of them to identify what one is causing the problem.  This way at least one can address the correct instance of the databases.  My feeling is that it is the DB that stores the SBS monitoring data.

Regards,
M
0
 

Author Comment

by:MikeASchreiner
ID: 16983874
hello itcoza,

I restarted the mssqlsbsmonitoring service and it restarted the SQL service that was hogging the most memory.
Should SQL Service Manager be Running the monitoring service? As it is running in the icon tray with a green triangle.
0
 
LVL 13

Accepted Solution

by:
itcoza earned 500 total points
ID: 16987114
MikeASchreiner,

Remember that the monitoring service that you see in the "icon tray" is not the SBSMonitoring DB, it is only a service that lets you know that the SQL services are running as they should.  Please note that SBS hosts a integrated monitoring and reporting service as part of the product and can sometimes go astray with the work it does.  What we need to find out now is if you have configured your SBS monitoring or not.

My suggestion would be to run the monitoring wizard again if you have in the past and then let it re-create all the monitoring processes that it runs to provide you and the clients on the network with information regarding the server and how it is being used.

Let me know if you get stuck.
*****************************
Regards, M
   
0
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.

 

Author Comment

by:MikeASchreiner
ID: 16987206
I'll run the wizzard again and let you know what happens.
0
 
LVL 7

Expert Comment

by:Zadkin
ID: 16987301
The alerts are not exeptional,  you can kill the alerts or modify the database see  http://msmvps.com/blogs/bradley/archive/2005/02/04/34984.aspx for the latter.
0
 

Author Comment

by:MikeASchreiner
ID: 16995979
Ok I re-ran the wizzard and I'm holding around 188,000K after 24 hours. It was getting up to 300,000K to 500,000K before so I think we got it under control now.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

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…
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

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