Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

SQL Server performance counters

Spotlight on SQL Server uses sys.dm_os_performance_counters (sysperfinfo for SQL Server 2000) to retrieve data for many of its displays. In some rare cases, this table may not contain information.

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.

Spotlight on SQL Server raises the shortly after connecting if it detects that the sysperfinfo or sys.dm_os_performance_counters table contains no data.

Verify the sys.dm_os_performance_counters table contains no data

Run the following SQL in the appropriate version of SQL Server Management Studio for SQL Server. If this query returns no records, then your SQL Server performance counters are missing. Spotlight on SQL Server will not be able to operate correctly.

select * from sys.dm_os_performance_counters

For SQL Server 2000 run the following SQL in Query Analyzer (select * from master..sysperfinfo)

Enable performance counters

Sometimes, for a variety of reasons, the SQL Server Performance Monitor counters will not show up as they should. Often, but not always, this problem can be fixed by following these steps.

  1. At the command prompt, type the following:

    unlodctr.exe MSSQLServer

  2. Then type:

    lodctr.exe <SQL Server path>\binn\sqlctr.ini

  3. Reboot the server.

More information

Open the SQL Server Knowledge Base at http://msdn.microsoft.com.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating