Microsoft KB Archive/268251

= INF: How to Identify Multiple Instances of SQL 2000 When You Use Performance Monitor =

Article ID: 268251

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q268251



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.

Additional query words: Resource utilization, multiple instances

Keywords: kbinfo KB268251

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.