Alerts in ApexSQL Monitor notify you about potential and ongoing performance issues with your machines, SQL Server instances, and databases. Alerts can be configured for each monitored machine, SQL Server instance, and/or database.
ApexSQL Monitor alerts enable you to configure three threshold values: low, medium, and high, as well as the period for metric capturing. The default period for metric capturing is 15 seconds. The minimal value for the time period is 1 s. Keep in mind that increasing this value can delay the metric collecting and make monitoring slower.
Alerts are grouped into three categories, based on their severity. Each alert severity is indicated by its status color. The number of triggered alerts is shown at the top of each performance metric tab.
As alerting is configurable, ApexSQL Monitor offers default values for the thresholds where applicable, but custom values can also be set.
If the metric has no default threshold values set due to the nature of metric (for example setting data and log file size thresholds for your databases may not make sense), the threshold values are shown as N/A.
Default threshold values are based on general recommendations and they might not apply to your monitoring goals and environment requirements. A huge number of alerts can be created, or some critical situations ignored if the thresholds are not adjusted to your specific environment.
How to set alerts in ApexSQL Monitor?
By default, ApexSQL Monitor enables alerting for the most important SQL Server performance metrics, like Buffer cache hit ratio, Deadlocks per second, Lock requests per second etc. For the rest of the metrics, like Batch requests per second and Compilations per second, must be enabled manually. Alerting can also be disabled for any of the metrics where alerting is enabled by default.
- Click Metrics in the menu
- Under the SQL Server instances on the left select the group or SQL Server instance for which you want to configure alerts
- Select the Alerting check-box
Enter the values for metric thresholds
Click Apply in the yellow notification at the top
To set identical alert thresholds for all databases on a SQL Server instance, select the SQL Server instance in the Servers list, scroll to the bottom of the metric list, and specify the thresholds in the Database measurements section. Use a similar method to specify identical alert thresholds for all SQL Server instances on a machine.
How to change ApexSQL Monitor alert settings?
Once alerting is set, it can be changed in the Configure metrics form, using the same steps followed for setting the alerts.
A list of raised alerts
The Review alerts form shows all alerts that have been raised on all SQL Server instances.
For each severity level, the number of raised alerts is shown.
How to clear alerts?
An alert remains active until it is cleared in the Review alerts form. After the alert is resolved it should be cleared. All raised alerts can be cleared, the alerts raised for a specific performance metric on all monitored SQL Server instances, or alerts raised for a specific performance metric on a specific SQL Server instance.
To clear alerts, select the adequate check box and click Apply in the yellow notification at the top.
ApexSQL Monitor will generate a new alert when the metric reached its predefined value again.