Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Deployment Guide

Welcome to Spotlight on SQL Server The size and shape of your deployment Install / Upgrade Spotlight data collection and storage View data and configure Spotlight Monitored connections in the deployment Deployment over the Windows network Monitored SQL Servers Monitored Windows Servers and hosts of database connections

5. Configure WMI permissions

Note: This is step 5 of the procedure for how to Configure WMI with minimum required user permissions.

Spotlight User is the windows user that will be used in the connection to the Windows server and/or Windows host of the database connection. For more information, see Configure | Connections.

From the Windows command prompt, type wmimgmt.msc and click Enter to open the WmiMgmt dialog.

  1. Right click WMI Control (Local) | Properties.
  2. Click Security.
  3. Expand the Root node. Select cimv2.
  4. Click the Security button to open security settings for WMI on this computer.
  5. Click Advanced to open the advanced security settings for this WMI namespace.

    Add the Spotlight User. Click Edit. Allow:

    • Execute Methods
    • Enable Account
    • Remote Enable
    • Read Security

    Ensure these permissions apply to this namespace and all the namespaces under it by selecting This namespace and subnamespaces in the Apply to drop down box.

    Click OK to save the new permissions.

  6. Click OK to close the Advanced Security Settings dialog. Click OK to close the Security for ROOT dialog.
  7. Returning to the Root node, select DEFAULT.
  8. Click the Security button to open security settings for DEFAULT.
  9. Click Advanced to open the advanced security settings.

    Add the Spotlight User. Click Edit. Allow:

    • Execute Methods
    • Enable Account
    • Remote Enable
    • Read Security

    Ensure these permissions apply to this namespace and all the namespaces under it by selecting This namespace and subnamespaces in the Apply to drop down box.

    Click OK to save the new permissions.

  10. Click OK to close all dialogs.

Data display and collection problems

Monitored Windows Servers and hosts of database connections > Data display and collection problems
Data Display Description

Windows Server | Home Page | Disks Panel

Windows Server Disks Drilldown

If disk counters are disabled on the monitored Windows Server you may notice the following:

  • The Spotlight home page Disks Panel and Disks Drilldown show no data.
  • Various I/O charts on the SQL I/O Activity tab and Windows Activities drilldowns, and disk graphs on the Databases drilldown show no data.
  • Errors executing "LogicalDisk" or "PagingFile" queries.

To enable disk counters

  1. Open a command line window on the monitored Windows Server.
  2. Type the following at the command prompt: diskperf -y
  3. Restart the Windows Server.

Windows Server | Network Drilldown

If the Network Drilldown | NBT page is displaying no data, the likely cause is that the appropriate performance counters are not enabled on the monitored Windows server.

To enable the collection of network data

  • Windows Server 2003: Use the Exctrlst utility to ensure the PerfNet counters are active on the Windows Server. Download Exctrlst from the Microsoft Web site (download).
  • Verify at least one network device is using NBT (NetBIOS over TCP/IP). To do this, check the properties of all network connections (in particular, Advanced TCP/IP Settings | WINS) to ensure that the NetBIOS setting is not disabled.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating