Including a workload in alert/exception reporting
Follow these steps to include a workload in alert/exception reporting.
Procedure
Set up an INCLUDE profile line that:
- Properly specifies the workload (plan, program, etc.)
- Excludes any SQLCODEs from alert/exception reporting for the workload
- Defines an exception limit greater than 0
- Specify Y in the Threshold Exceptions field and specify the appropriate exception thresholds.
- Specify N in all Anomaly-based Exceptions fields (CPU Anomalies, Elapsed Anomalies, Getpage Anomalies).
- Specify Y in the Threshold Alerts field and specify the appropriate alerts thresholds.
- Specify N in all Anomaly-based Alerts fields (CPU Anomalies, Elapsed Anomalies, Getpage Anomalies).
Note:
- All work is excluded from exception reporting until a filter is set up to specifically include it.
- It is recommended that you name your workload by filling in the optional Workload Name field on the Insert (or Update) Profile Line panel to facilitate the identification of the monitoring profile line and workload with which captured activity is associated.