Multiple instances of SQL

According to the Task Manager, on my SBS 2003 Server, I'm running multiple instances of SQL. How do I determine which instance(s) are required to maintain server stability, and which are not. My Server resource use continues to be a perennial problem. Please advise.

Hi,

perhaps this article at Database Journal help Monitoring SQL Servers Availabilty.

|||

You most likely have the following instances, for the stated purposes.

MSSQL$SHAREPOINT -necessary if you are using Sharepoint Services
MSSQL$SBSMONITORING - necessary for internal usage of SBS

MSSQLSERVER - Default SQL Server that may be used by your applications.

Other instances may be installed and required for various third party products.

I would not stop the first two, and only stop the third IF there are no applications requiring SQL Server.

It really sounds like you need to explore more memory or CPU power for your SBS server.