INF: How to Identify Multiple Instances of SQL 2000 When You Use Performance Monitor (268251)

SUMMARY

If you run multiple instances of Microsoft SQL Server 2000 on the same system and you want to track the resource utilization of each instance in the Performance Monitor (PerfMon), you must distinguish the instances by their server process IDs (PIDs) by using the SQL Server errorlog.

MORE INFORMATION

In Performance Monitor, add the following information:

Object  :  Process
Counter :  ID Process
Instance:  You should see multiple SQL Server instances listed, SQL Server, SQL Server#1, SQL Server#2, and so forth. Add them all.

The value for this counter has the process id (PID) for the SQL Server instance. In the SQL Server errorlog for each instance you will see a line that indicates which process ID the particular instance is using:

2000-01-20 15:37:58.72 kernel   Copyright (C) 1988-2000 Microsoft Corporation.
2000-01-20 15:37:58.72 kernel   All rights reserved.
2000-01-20 15:37:58.72 kernel   Server Process ID is 999.

Match up the instance to the PID and the instance name (SQL Server, SQL Server#1, SQL Server #2, and so forth) in PerfMon. Then, look at events that correspond only to the SQL Server instance that you are concerned about.