Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Task Manager I see two instances of sqlserver.exe. One is consuming a significant number of resources, so I'd like to attempt to harness it in a bit. How do I determine which database this corresponds to?

The two SQL Server DB's we have are for Sharepoint and SBSMonitoring, both of which have a sqlserver.exe in their respective \Binn directories. I suspect that the SBSMonitoring is the one which is allocating resources, since Sharepoint rarely has any changes to it. However, I'd like to verify this for sure, and Task Manager doesn't seem to be the tool to find that info.

This is Windows SBS 2003, with SQL 2000.

share|improve this question
up vote 1 down vote accepted

One way to do it would be to view the PID column in Task Manager, find the PID for each instance of SQL Server, and compare that to the PID in the current SQL Server log for each instance.

share|improve this answer
Thanks, that worked. And for the record, I was correct that the SBSMonitoring instance is the larger. – merv Jan 7 '13 at 17:16
Glad to help... – joeqwerty Jan 7 '13 at 17:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.