Spotlight Enterprise uses the SQL Server virtual table sysperfinfo to retrieve data for many of its displays. In some rare cases, this table may not contain information. When this is the case, Spotlight Enterprise will not be able to collect the data it requires, and will display '0' for many of its metrics. Most obvious will be the Memory icons on the Spotlight Overview page, which will show 0 MB of memory used by Amazon RDS for SQL Server. Also, many of the flows on the Spotlight Overview page will show no activity, and many drilldowns will show incomplete information.
Spotlight Enterprise raises an informational alarm shortly after connecting if it detects that the sysperfinfo table contains no data.
You can confirm the existence of this problem by running the following SQL query on Amazon RDS for SQL Server in SQL Server Management Studio:
select * from sys.dm_os_performance_counters
If this query returns no records, then your SQL Server performance counters are missing and Spotlight Enterprise will not be able to operate correctly.
Sometimes, for a variety of reasons, the SQL Server Performance Monitor counters will not show up as they should.