Solved

SBS 2003 sqlservr.exe service memory keeps building!

Posted on 2006-06-26
6
591 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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

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!

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've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

622 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