Introduction
DPA currently offers an alert called Database Instance Wait Time Anomaly, which notifies you when the overall instance wait times exceed normal levels. Some customers have requested a more granular approach, allowing alerts to focus on individual databases within an instance. This new alert is designed to address that need.
Note: This alert is compatible with all database types except Oracle, as Oracle does not utilize a database concept similar to SQL Server and others. It leverages data from the DPA repository, ensuring no additional load is placed on the monitored instances.
Create the Alert in DPA
To set up the alert, create a Custom SQL Multiple Numeric alert, then paste the provided SQL statement into the alert configuration. Configure the alert to match the example shown below. The thresholds are based on how many standard deviations the current wait time exceeds the normal values. For instance, if the deviation is 2 times above normal, the alert triggers a warning. If it exceeds 3 times the normal value, it triggers a critical alert.
