Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

Data display and collection problems - SQL Server connection

Known issues where unknown values or missing values or too many "0" values are shown on the SQL Server home page or its drilldowns.


<Unknown> entries in the All Workload | Database tree and SQL not available entries in the All Workload | Statement tree may mean:

  • SQL Server did not add the metric to the event. Perhaps the metric was too difficult to get or the metric was no longer available.
  • The event was created by a process that does not have that metric. Typically these are internal SQL Server processes.

When SQL Server performance counters are missing, Spotlight will not be able to collect the data it requires, and will display "0" for many of its components. Most obvious will be the Memory icons on the , which will show 0 MB of memory used by SQL Server. Also, many of the flows on the home page will show no activity, and many drilldowns will show incomplete information.

If errors are displayed on the SQL Activity drilldown | Sessions page then install SQL Server Management Tools on the Spotlight Diagnostic Server host. The version of SQL Server Management Tools required is dependent on the most current version of SQL Server monitored. When monitoring SQL Server 2012, SQL Server 2012 Management Tools are required.

The Spotlight log in to the SQL Server instance must be a member of the sysadmin server role to view the data on this page.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating