WMI-Counters not working on Windows 2003 Server?

[Jtb]

Hi,

I had a lot of troubles with WMI on my W2k3 machines and want to share the solution.

Symptoms: the wmi class of the wanted performance counter is not available but you can the see the performance counter in Administrative Tools\Performance

Solution: try
wmiadap /f and restart the wmi-service..

Reason: windows deletes wmi classes:

This problem occurs because Windows Management Instrumentation (WMI) uses AutoDiscovery/AutoPurge (ADAP) to build its internal performance counter table. If the Exchange Server 2003 services are not started when the WMI ADAP process is started, the performance counters are not transferred to WMI.

Further information:
KB820847
KB827260

[Jtb]

btw: fast way to create wmi-scripts or check if a wmi class is available: scriptomatic.

Scriptomatic can be found at the MS Script Center

[Izzy]

Thanks for sharing! I had the same problem and this fixed it.

[dev2dev]

thanks jtb,
thank you very much

i was trying to work around with the sqlserver script posted in addons by devilsun. I can see the script giving output now, but have to waite for some more time to get the real graph

thanks again

[lightspeed]

When I try running the "wmiadap /f" command, it results in some errors in the Application Event Log like this one:

"WMI ADAP was unable to create the object Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager for Performance Library MSSQLSERVER because error 0x80041002 was returned"

Unsurprisingly, this WMI class is still not present in the namespace after running the command. I can't find any information on the meaning of the error code, and haven't been able to resolve this.

I am currently using a workaround of accessing these counters using PerfMon rather than WMI, but WMI would be preferable. Does anyone know how to solve this?

[Jtb]

Do you have WMI provider for MS SQL Server installed? It is not installed
with SQLServer and is located on your CD, in \x86\other\wmi directory.

[lightspeed]

Ah okay I didn't know the WMI provider was not installed by default. However, the path you mention seems to only apply to the SQL Server 2000 CD.

The particular system I am trying to monitor is running SQL Server 2005. Also, I can see some SQL related classes in WMI, but just not the "Win32_PerfFormattedData_MSSQLSERVER*" classes. (The Win32_PerfRawData_MSSQLSERVER*" classes are present, though).

[freejmx]

Can you sell context ads here?
If yes, CPM or CPC?

[schnapsten]

Hello!!What can I do if WMI does not provide the capabilities I need? thanks in advance))

[BSOD2600]

Write your own?