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

This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 235555 (SHILOH)
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 InstanceSQL Server: Access Methods           MSSQL$SQL1:Access MethodsSQL Server: Backup Device            MSSQL$SQL1:Backup DeviceSQL Server: Buffer Manager           MSSQL$SQL1:Buffer ManagerSQL Server: Cache Manager            MSSQL$SQL1:Cache ManagerSQL Server: Databases                MSSQL$SQL1:DatabasesSQL Server: General Statistics       MSSQL$SQL1:General StatisticsSQL Server: Latches                  MSSQL$SQL1:LatchesSQL Server: Locks                    MSSQL$SQL1:LocksSQL Server: Memory Manager           MSSQL$SQL1:Memory ManagerSQL Server: Replication Agents       MSSQL$SQL1:Replication AgentsSQL Server: Replication Dist.        MSSQL$SQL1:Replication Dist.SQL Server: Replication Logreader    MSSQL$SQL1:Replication LogreaderSQL Server: Replication Merge        MSSQL$SQL1:Replication MergeSQL Server: Replication Snapshot     MSSQL$SQL1:Replication SnapshotSQL Server: SQL Statistics           MSSQL$SQL1:SQL StatisticsSQL 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.
More information
Only counters for those SQL Servers started prior to opening Performance Monitor are available.
perfmon performance monitor

Article ID: 272433 - Last Review: 01/16/2015 20:42:19 - Revision: 4.0

  • Microsoft SQL Server 2000 Standard Edition
  • kbnosurvey kbarchive kbbug kbpending KB272433