Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 268251 - Last Review: November 6, 2003 - Revision: 3.2
INF: How to Identify Multiple Instances of SQL 2000 When You Use Performance Monitor
This article was previously published under Q268251
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.
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.
APPLIES TO
- Microsoft SQL Server 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate