Microsoft KB Archive/827260

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

Article ID: 827260

Article Last Modified on 10/25/2006

-

APPLIES TO


 * Microsoft Operations Manager 2000 Service Pack 1
 * Microsoft Operations Manager 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Standard Edition

-





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:  Click Start, and then click Run. In the Open box, type cmd, and then click OK. 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

 At the command prompt, type exit, and then press ENTER to close the command prompt.

Keywords: kbperformance kbinterop kbnofix kbbug KB827260

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.