-
Title
How to check that the WMI connections are working within Spotlight on SQL Server Enterprise? -
Description
Is there a way to verify that WMI on either the machine where the Diagnostic Server Service is installed, or any machines being monitored, is working?
-
Cause
Not having WMI enabled or working properly could stop Spotlight on SQL Server Enterprise from monitoring the server machines properly.
-
Resolution
The attached word document gives details on how to troubleshoot WMI connection problems that may be occurring within the environment.
-
Attachments
-
Additional Information
1) If there are memory leaks with WMI on Windows 2008 R2, check on the Microsoft website
for hotfixes.
2) Quest does not have control over WMI, but Spotlight on SQL Server Enterprise relies on data it returns. When it doesn’t work, our queries fail. The rule of thumb is to check outside of Spotlight if the Win32_ServerSession WMI class is available and returns data.
Run the command below on the Diagnostic Server-machine next time Spotlight reports the same problem:wmic /node: 'MonHost' /user: DOMAIN\UserName path Win32_ServerSessionIf it returns an error, Quest suggest performing a "Repair" of the WMI, for example, using utility below:
http://www.microsoft.com/downloads/details.aspx?familyid=d7ba3cd6-18d1-4d05-b11e-4c64192ae97d&displaylang=enThis article http://msdn.microsoft.com/en-us/library/windows/desktop/aa389286%28v=vs.85%29.aspx gives an explanation of how WMI communicates and how to configure the firewalls on two machines.