Return
-
Title
Alarms by time and Playback data is not being displayed -
Description
When trying to view details in the playback dropdown or when trying to view the details in the Alarms by Time window , the data never loads. The playback history remains grey and the Alarms by Time just displays "(loading...)". -
Cause
-
Resolution
RESOLUTION
1.Run the following SQL Select statement and prove that there is data for that connection for today
so for the spotlight_playback_alarms table on the SpotlightPlaybackDatabases run the following:SELECT * FROM spotlight_playback_alarms
WHERE pb_me_name LIKE '%<CONNECTION_NAME>%'
AND pb_timestamp > '13-JUN-2013' -- date not being recorded for
AND pb_package_name = 'sqlserver_spotlight';2.If data is being stored in the DB then go to Configure|Diagnostic Server and click on 'Configure the Playback Database' and see what the store playabck data is set to for the correct instance.
3.If it is set to collect for the days you wish to view then restart the SQL Service
4.Restart the Spotlight Diagnostic Server Service