Spotlight on SQL Server Enterprise 11.7 - Release Notes

Troubleshooting WMI

Spotlight uses WMI queries to retrieve performance counter information from Windows Server (and SQL Server host). Spotlight needs access to this information before it can connect to Windows Servers (and SQL Server hosts).

WMI Test 1

This test checks that requests are reaching WMI.

Run this test from the Windows server being monitored.

1. Click Control Panel | Administrative Tools | Event Viewer to open the Event Viewer.
2. Click View | Show Analytic and Debug Logs to select this menu option.
3. Click Applications and Service Logs
4. Click to expand Microsoft | Windows | WMI-Activity

5. Right click Trace | Enable Log.

   Tip: To save log entries, right click Trace | Save All Events As.

6. If nothing is displayed then the request never reached WMI. The issue is a security or networking issue.

   If events with error messages are displayed then those events can be investigated. If you encounter WMI errors: For more information, see WMI errors.

WMI Test 2

This test checks that Microsoft tools can connect to WMI.

Run this test from the Spotlight Diagnostic Server.

1. Login to the Spotlight Diagnostic Server under the account used to run the Spotlight Diagnostic Server.
2. Click Control Panel | Administrative Tools | Computer Management.
3. Right click Computer Management (Local) | Connect to another computer.
4. Specify the \\HOSTNAME where HOSTNAME is the name of machine you want to monitor with Spotlight.
5. Click Services and Applications.
6. Right click WMI Control | Properties to open the WMI Control Properties dialog.
7. Ensure the General tab is open.

If successful, try to monitor HOSTNAME with Spotlight again.

WMI Test 3

This test checks that WMI is working and returns data properly.

If you encounter WMI errors: For more information, see WMI errors.

1. Run this command on the machine you want to monitor. Run this command locally from the command prompt.

   wmic path Win32_PerfRawData_PerfDisk_LogicalDisk get FreeMegabytes

    

2. Run either of the following commands on the Spotlight Diagnostic Server.

   wmic /node: HOSTNAME /user: DOMAIN\USER path Win32_OperatingSystem get BuildNumber, Caption, CSDVersion, Version

   or

   wmic /node: HOSTNAME /user: DOMAIN\USER path Win32_PerfRawData_PerfDisk_LogicalDisk get FreeMegabytes

   HOSTNAME	Identify the host computer you want to monitor with Spotlight. Use the fully qualified domain name, machine name or IP-address.
   DOMAIN\USER	Valid Windows login credentials.

Additional testing

You may want to consider a WMI Diagnostic Utility provided by Microsoft. It is a utility to help system administrators diagnose and repair problems with the WMI service. See: http://www.microsoft.com/en-us/download/details.aspx?id=7684.