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

Posted on 2006-04-21
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
    LVL 8

    Accepted Solution

    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
    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 -- you should... because it handles memory issues much better.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    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…
    Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
    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…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now