The Playback facility allows you to view events and data collected in the recent past on Spotlight Overview pages, connection drilldowns and Spotlight Today. Once a time is selected, the display of the Connection drilldown and Spotlight Today turns to that time. Playback time to capture the event or moment in Spotlight as though it was happening in real time.
Using the Playback facility
- Select a connection.
- Select from the available options on the Monitor | Playback ribbon tab.
|Playback||Select an alarm or moment in time in the past to return to. Click Real Time to return to the present time.|
|Select the date. Use the back and forward buttons to change the date.|
|Select the time of day. Press and hold to magnify the time scale. The time scale is colored according to the most severe alarm raised against the connection at that time.|
|The alarms list shows alarms raised on the selected day. It scrolls to show those alarms raised at the given time. Select an alarm to playback to the time when the alarm was raised.
Use the Search field above the table to quickly locate an alarm. The list of alarms is filtered to match the text you type in the search field.
|Real Time||Return to present time.|
|Rewind||Go back in time. Click the associate arrow to define how far back in time to travel: 1 minute, 5 minutes, 10 minutes, 1 hour, 2 hours, 6 hours, 12 hours or 1 day.|
|Skip||Starting from the past, skip forward in time. Click the associate arrow to define how far forward to skip: 1 minute, 5 minutes, 10 minutes, 1 hour, 2 hours, 6 hours, 12 hours or 1 day.|
|Play||Starting from the past, step forward in time through the alarms in sequence. Click the associate arrow to define the speed of play.|
Note: For SQL Server Azure SQL Managed Instance, and Windows Server connections, only the current display name (as defined by SQL Server Connection Properties, Connection Details for Azure SQL Managed Instance or Windows Server Connection Properties will be used. The Spotlight Playback Database does not store/show historical display names.
Note: Playback data is not displayed for SQL Azure database connections.
Tip: On the Spotlight Overview page you can view the recent history of a single component.
Configuration and deployment
|Configuration and deployment||Description|
|Configure the Playback Database||Click to re-enter connection details to the Playback Database, create a new Playback Database or specify the number of days that data will be stored in the Playback Database. The number of days specified corresponds to the number of days of history available to Playback. The default is seven days. The minimum is two days.|
|Configure | Scheduling||Playback data is collected at scheduled intervals, in response to some alarms, and also while viewing a drilldown using the Spotlight client. This means that history data may not be available for a drilldown in Playback mode. You may want to set the rate at which data is collected.|
|Playback Database||The Playback Database is stored on SQL Server. Employ maintenance procedures and back up the Playback Database regularly.|