The following alarms are configurable to collect (not collect) additional diagnostic information. When configured to collect additional information and the alarm is activated to the severity to trigger data collection then data is captured in the Playback Database.
Compiles - Percentage Recompilations Alarm
Severity to trigger data collection
High
Data Collection Default
On
To show this drilldown: select the alarm in the alarm log and click Diagnose.
SQL Server | SQL Activity Drilldown | Summary page
For additional information: select the alarm in the playback database and navigate to this drilldown.
SQL Server | SQL Activity Drilldown | Sessions page
Locks - Blocked Processes Alarm
Severity to trigger data collection
High
Data Collection Default
On
To show this drilldown: select the alarm in the alarm log and click Diagnose.
SQL Server | SQL Activity Drilldown | Blocking page
For additional information: select the alarm in the playback database and navigate to this drilldown.
SQL Server | SQL Activity Drilldown | Sessions page
Locks - Deadlocks Alarm
Severity to trigger data collection
High
Data Collection Default
On
To show this drilldown: select the alarm in the alarm log and click Diagnose.
SQL Server | SQL Activity Drilldown | Deadlocks page
For additional information: select the alarm in the playback database and navigate to this drilldown.
SQL Server | SQL Activity Drilldown | Sessions page
Memory - Page Life Expectancy Alarm
Severity to trigger data collection
High & Medium
Data Collection Default
On
For additional information: select the alarm in the playback database and navigate to this drilldown.
SQL Server | SQL Activity Drilldown | Sessions page
SQL - Long Running SQL alarm
Severity to trigger data collection
High & Medium & Low
Data Collection Default
On
To show this drilldown: select the alarm in the alarm log and click Diagnose.
SQL Server | SQL Activity Drilldown | Sessions page
For additional information: select the alarm in the playback database and navigate to this drilldown.
SQL Server | SQL Activity Drilldown | Sessions | Session Details
SQL Agent - Alerts Alarm
Severity to trigger data collection
High & Medium
Data Collection Default
On
To show this drilldown: select the alarm in the alarm log and click Diagnose.
SQL Server | Support Services Drilldown | SQL Agent Alerts page