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?
Not having WMI enabled or working properly could stop Spotlight on SQL Server Enterprise from monitoring the server machines properly.
The attached word document gives details on how to troubleshoot WMI connection problems that may be occurring within the environment.
1) If there are memory leaks with WMI on Windows 2008 R2, check on the Microsoft website
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:
This 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.