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