Introduction
DPA collects the Page Life Expectancy (PLE) metric and uses default thresholds of 300 seconds for critical alerts and 600 seconds for warnings. Alerts can be configured based on this metric. However, some users have requested the ability to suppress these alerts during periods when UPDATE STATISTICS or BACKUP commands are running. This alert configuration allows for that behavior.
Alert Definition
Create a custom alert of type Custom SQL - Multiple Numeric, modeled after the example below. When triggered—provided no UPDATE STATISTICS or BACKUP operations were running at the time—the alert will return a list of SQL statements sorted by logical reads. These are likely the statements responsible for the drop in Page Life Expectancy (PLE).
