Issue monitoring clustered SQL Server - WMI Cannot Connect

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Issue monitoring clustered SQL Server - WMI Cannot Connect

Postby » Thu Jun 20, 2013 8:22 pm

Can someone help me out with this. I'm trying to monitor a cluster. Everything connects just fine with the exception of the actual cluster itself. We receive the following error in the SQL Monitor log.

GetInstances: Root\\MSCluster select State,Name,Description,Type,__RELPATH from MSCluster_Resource

Any help would be greatly appreciated.

Kevin Monroe
SQL Server DBA
Posts: 5
Joined: Thu Dec 06, 2012 7:34 pm
Location: Pennsylvania, US

Postby chriskelly » Mon Jun 24, 2013 2:03 pm

Please can you run the WMI test which is detailed in this document. It utilised the wbemtest utility which is provided by Microsoft.

However, at step 3 please can you specify the namespace "\\\\\\root\\MSCluster" and at step 6 use the query "select State,Name,Description,Type,__RELPATH from MSCluster_Resource". These are taken from your error message and will ensure that the test results are relevant.
Chris Kelly
Technical Support Engineer
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 1 guest