SQL server sensors not working

Votes:

0

Your Vote:

Up

Down

HI guys, I get the following error when trying to use ANY of the SQL sensors:

Class(es) not found: "Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics"

The same server has 25 other sensors all running fine (many of which are WMI), and I have used the SQL sensors successfully on other servers.

Any ideas?

prtg sql wmi

Created on May 8, 2011 7:01:03 AM by  phil (0) 1



7 Replies

Votes:

0

Your Vote:

Up

Down

Hello,

that might be a problem on the target hosts WMI, please see if you can fix it with any of the tips from our "WMI Repair"-article: WMI Repair List

best regards.

Created on May 9, 2011 1:41:43 PM by  Torsten Lindner [Paessler Support] (15,450) 3 1



Votes:

0

Your Vote:

Up

Down

Thanks, I have already checked that list but this issue is not related to a WMI problem as many other sensors that are using WMI on the same box are working just fine.

I am only seeing this error with the SQL sensors on this one box.

Created on May 10, 2011 10:47:34 AM by  phil (0) 1



Votes:

0

Your Vote:

Up

Down

It still possible that only the WMI Classes for the SQL-Server are missing or not correctly set up, which the error-message kind of suggests "Class(es) not found: "

Created on May 10, 2011 1:51:03 PM by  Torsten Lindner [Paessler Support] (15,450) 3 1



Votes:

0

Your Vote:

Up

Down

I am having the exact same issue. Is there is a quick fix to get the WMI classes for SQL working? I know the proper services are running and I tried to execute the following command within the SQL server:

mofcomp "c:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"

Microsoft (R) MOF Compiler Version 6.0.6000.16386 Copyright (c) Microsoft Corp. 1997-2006. All rights reserved. Parsing MOF file: c:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlmgmpr oviderxpsp2up.mof MOF file has been successfully parsed Storing data in the repository...

Need help, very annoying.

Thanks! Done!

Created on Jun 20, 2011 8:13:44 PM by  David Dinner (0) 1



Votes:

0

Your Vote:

Up

Down

Same issue here. SQL WMI counters working fine from PRTG Probe Server using PerfMon under the same credentials, but throws this error when used within PRTG.

Any suggestions?

Created on Jul 20, 2011 8:12:26 AM by  Stuart Hall (0) 1



Votes:

0

Your Vote:

Up

Down

Same problem here! Cannot monitor my SQL Database!

Created on Jul 25, 2011 4:08:24 PM by  awitek (0) 1



Votes:

0

Your Vote:

Up

Down

Our research shows some inconsistencies of how Microsoft is naming the classes depending on SQL Server Edition, Windows Version, Instancing. We're still investigating this matter.

However, if you want to help us in this case, please use Microsofts WBEMTest tool and try to find the classes concerning the MSSQLserver you want to monitor.

If successful please send your findings including a short description of your SQL Server System (SQL Server Edition, Windows Version, Instancing, Service Pack Levels etc.) to support@paessler.com - we appreciate any input.

Kind regards,

- Volker

Created on Jul 29, 2011 9:39:57 AM by  Volker Uffelmann [Paessler Support] (1,547) 2 3



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.

PRTG
Network Monitor
Intuitive to Use.
Easy to manage.

150.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Visit
www.paessler.com

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

Top Tags


View all Tags