SQL Server 2000 Performance Counters Do Not Appear in the Performance Collection Rules of the SQL Server Management Pack (827260)


The information in this article applies to:

  • Microsoft Operations Manager 2000
  • Microsoft Operations Manager 2000 Application Management Pack
  • Microsoft SQL Server 2000 (all editions)

SYMPTOMS

When you turn on the performance collection rules in the SQL Server Management Pack Module for Microsoft Operations Manager (MOM) 2000 server, the SQL performance counters may not be collected. When this problem occurs, the MOM Administrator Console may contain no performance data for named instances of SQL Server 2000.

CAUSE

This problem occurs because Windows Management Instrumentation (WMI) uses AutoDiscovery/AutoPurge (ADAP) to build its internal performance counter table. If the Microsoft SQL Server 2000 services do not start when the WMI ADAP process starts, the performance counters are not transferred to WMI.

WORKAROUND

To work around this problem, force the transfer of all the performance libraries. To do so, follow these steps:
  1. Click Start, and then click Run.
  2. In the Open box, type cmd, and then click OK.
  3. At the command prompt, type the following command as appropriate for your operating system, and then press ENTER:

    Microsoft Windows Server 2003

    wmiadap.exe /f

    Microsoft Windows 2000

    winmgmt /resyncperf

  4. At the command prompt, type exit, and then press ENTER to close the command prompt.
Modification Type:MajorLast Reviewed:10/27/2003
Keywords:kbPerformance kbinterop kbnofix kbBug KB827260 kbAudITPRO
©2003 Microsoft Corporation. All rights reserved.