0

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.

1 Answer 1

1

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.

2
  • Thanks, that worked. And for the record, I was correct that the SBSMonitoring instance is the larger.
    – merv
    Jan 7, 2013 at 17:16
  • Glad to help...
    – joeqwerty
    Jan 7, 2013 at 17:19

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .