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 kmonroe@psecu.com » 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.

Thanks,
Kevin
Kevin Monroe
SQL Server DBA
kmonroe@psecu.com
 
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.

http://documentation.red-gate.com/x/1wCi

However, at step 3 please can you specify the namespace "\\\\myserver.example.com\\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
chriskelly
 
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 0 guests