Spotlight Enterprise uses the SQL Azure 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 SQL Azure. 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 in SQL Server Management Studio:
select * from sys.dm_os_performance_counters