BUG: SQL Server Books Online Incorrectly States the Names of the SQL Server 2000 Counters for Named Instances

Article translations Article translations
Article ID: 272433 - View products that this article applies to.
This article was previously published under Q272433
BUG #: 235555 (SHILOH)
Expand all | Collapse all


In the SQL Server Books Online topic Using SQL Server Objects, SQL Server object names are all listed as beginning with "SQL Server"; however, for SQL Server 2000 named instances the SQL Server object names actually show up in Performance Monitor as "MSSQL$InstanceName." If there is a SQL Server 7.0 instance or default SQL Server 2000 instance on the same computer as one or more SQL Server 2000 instances, the SQL Server 7.0 or default SQL Server 2000 instance counters show up as "SQL Server."

In this example, the SQL Server 2000 Instance Name is SQL1:
Books Online Counter Name            Actual SQL Server 2000 Counter Name for named Instance

SQL Server: Access Methods           MSSQL$SQL1:Access Methods
SQL Server: Backup Device            MSSQL$SQL1:Backup Device
SQL Server: Buffer Manager           MSSQL$SQL1:Buffer Manager
SQL Server: Cache Manager            MSSQL$SQL1:Cache Manager
SQL Server: Databases                MSSQL$SQL1:Databases
SQL Server: General Statistics       MSSQL$SQL1:General Statistics
SQL Server: Latches                  MSSQL$SQL1:Latches
SQL Server: Locks                    MSSQL$SQL1:Locks
SQL Server: Memory Manager           MSSQL$SQL1:Memory Manager
SQL Server: Replication Agents       MSSQL$SQL1:Replication Agents
SQL Server: Replication Dist.        MSSQL$SQL1:Replication Dist.
SQL Server: Replication Logreader    MSSQL$SQL1:Replication Logreader
SQL Server: Replication Merge        MSSQL$SQL1:Replication Merge
SQL Server: Replication Snapshot     MSSQL$SQL1:Replication Snapshot
SQL Server: SQL Statistics           MSSQL$SQL1:SQL Statistics
SQL Server: User Settable Object     MSSQL$SQL1:User Settable Object


A new format was needed to accommodate named instances in SQL Server 2000.


Microsoft has confirmed this to be a problem in SQL Server 2000.


Only counters for those SQL Servers started prior to opening Performance Monitor are available.


Article ID: 272433 - Last Review: October 3, 2003 - Revision: 3.2
  • Microsoft SQL Server 2000 Standard Edition
kbbug kbpending KB272433

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com