Solved

SBS 2003 sqlservr.exe service memory keeps building!

Posted on 2006-06-26
6
585 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
[X]
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
  • 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
Technology Partners: 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!

 

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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

This guide is intended for migrating Windows 2003 Standard with Exchange 2003 to Windows Small Business Server 2008. You will need the following: Exchange Best Practice Analyzer: http://www.microsoft.com/downloads/details.aspx?FamilyID=DBAB201F-…
This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Small Business Server 2011. NOTE: This guide has been written using the preview version of SBS2011 therefore some of the screens may …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

734 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