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

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.

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.

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.