WMI-Counters not working on Windows 2003 Server?

Jtb · Joined: 19 Aug 2004 Posts: 30 Location: Germany

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:

Jtb · Joined: 19 Aug 2004 Posts: 30 Location: Germany

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 · Guest

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

dev2dev · Posted: Mon Dec 13, 2004 1:23 am Post subject:

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 · Joined: 20 Jul 2006 Posts: 3

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 · Joined: 19 Aug 2004 Posts: 30 Location: Germany

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 · Joined: 20 Jul 2006 Posts: 3

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).