[Last Call] Learn how to a build a cloud-first strategyRegister Now


Multiple instances of sqlservr.exe in task manager on SBS 2003

Posted on 2006-04-21
Medium Priority
Last Modified: 2013-12-03
I currently manage 4 SBS 2003 installations.  We ran into the issue at one installation of Exchange store.exe taking a large amount of memory and we recieved the warning.  I've doen the research and have plans to deal with that.  In my investigation, however, I came across the task "sqlserver.exe".  I have never setup a SQL server on the system.  More strange yet is that i noticed that there was not one, but TWO instances of sqlservr.exe running on the server.  In case it matters I am remotely connected at this point.

To expand my search, i remoted to my other 3 installations.  One of the other three had the same situation.  So I have two installations that have two instances running, and I have the other two installations with only one instance running in the task manager.

The two sites that have two instances are both running exchange 2003, serving as their mail servers (internal and external).  Both are running Trend Micro Server/Client/Messaging Suite for virus protection.

Of the two other sites.  They are both running exchange as their mail servers (internal and external).  One is protected by Symantec and the other the same Trend Micro product.

I can't seem to put things together to come up with a reason why some are doing it and others aren't.  The main reason I'm asking is because these are taking large amounts of memory in proportion to the number of users they service.

Any advice?  Thanks
Question by:compsol1993

Accepted Solution

Saineolai earned 600 total points
ID: 16507392
You may have multiple instances of SQL running on SBS,

Look at this URL to help identify them,

LVL 74

Assisted Solution

by:Jeffrey Kane - TechSoEasy
Jeffrey Kane - TechSoEasy earned 400 total points
ID: 16507684
The default installation will have TWO instances of MSDE which show up as sqlservr.exe in the task manager.  If you looked at your "services" msc you would see them there:  MSSQL$SBSMONITORING and MSSQL$SHAREPOINT.  My guess is that you either didn't install SharePoint or Monitoring on the other sites.

The above linked article is a good thing to follow for regulating the resources of these.

The Exchange Store issue generally isn't a problem because Exchange will take up whatever RAM is empty, pretty much.  But it will also let it go quite easily.  If you haven't already installed Exchange SP1 (along with SBS SP1 -- http://sbsurl.com/sp1) you should... because it handles memory issues much better.


Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
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…
Suggested Courses
Course of the Month17 days, 22 hours left to enroll

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