Hi there,

we use 3 database-servers ... the first one runs SQL 2008 and I can do WMI-checks for locks and statistics without problems.

But when I add a similliar sensor for SQL 2014 on our SQL 2014 DB-servers, I get the following error message:

Classe not found: "Win32_PerfRawData_MSSQLSQLPROD_MSSQLSQLPRODLocks" (Code: PE235)

The DBs instance name is "SQLPROD", so I think that's the correct class.

Can somebody please help me?

Thanks!

Marcel

Article Comments

Dear Marcel

Please use the WMI tester to run this query on the SQL 2014 server:

SELECT ServiceName,DisplayName FROM SQLService WHERE SQLServiceType = 1

Please use this namespace for the query: root\Microsoft\SqlServer\ComputerManagement12

What output are you getting for "ServiceName"?


Sep, 2016 - Permalink

Hi,

can you please provide more Information regarding tht wmi-tester?

I entered domain, ip, credentials and password for a sysadmin-user, in advanced I check "custom" and enter the SQL Statement and the Namespace.

The output is 80041008 - one of the parameters to the call is not correct.

I guess there's an error with the Format of the credentials ...

Thanks again.


Sep, 2016 - Permalink

Not I got it - the output for the servicename is MSSQL$SQLPROD - it's the same output as the sensor from PRTG automatically detects. But it still doesn't work on our productive servers.

By the way - I also found a SQL2014-testserver on which I can use the SQL2014-sensor without problems.


Sep, 2016 - Permalink

Dear Marcel

Since WMI is Microsoft's WBEM implementation, you can use the Wbemtester (included with Windows) to list all WMI classes. Please open the Wbemtester. Use the "Connect ..." option to connect to the namespace root\Microsoft\SqlServer\ComputerManagement12

Then please use "Enum Classes". Leave the superclass name empty, but select the "Recursive" option and confirm with "OK". It takes a while to collect all classes.

Are you finding the class in question, in32_PerfRawData_MSSQLSQLPROD_MSSQLSQLPRODLocks? If not, can you find a class with a similar name?


Sep, 2016 - Permalink

Hi,

sorry, I can't find that class. I get a list of 85 objects and for SQL I can only find classes named like SQLErrorLogEvent, SQLErrorFile, SQLServerAlias, SQLService etc.

Interesting - when I run this tool on the server with a working locks-WMI sensor, I do find the same classes but also not "PerfRawData_MSSQLSQLPROD_MSSQLSQLPRODLocks"


Sep, 2016 - Permalink

Dear Marcel

In this case please check if there are any other classes which end on "Locks". You can also try different roots like \root\Microsoft\SqlServer\ComputerManagement10, 11, 12, 13 (these mark different SQL server versions.)


Sep, 2016 - Permalink

Sorry, can't find any classes that end on "lock" ... and entering any other root results in "invalid namespace"


Sep, 2016 - Permalink

In this case, please contact us via support@paessler.com Please include a description of this issue, you can also add a link to this KB entry.


Sep, 2016 - Permalink