This article provides information on how to properly configure ApexSQL Monitor including the configuration of metrics, alert parameters and maintenance periods
Configuring metrics – By clicking the Metrics button, the Configure metrics window will be displayed. Here parameters related to metrics and alerts can be configured
- Select the All instances node and set the System and SQL Server parameters that are global for all monitoring instances. These will be applied to all monitored computers and SQL Servers
- Navigate to each computer node and change the desired settings in the right pane. This way, system and SQL Server settings changed will be applied only to that computer and its child SQL Servers
To set up some metrics values for specific SQL Servers, navigate to each SQL Server node and change desired settings like threshold values, metrics period, alerting period etc. Changes will be applied only to the corresponding SQL Server selected in the left pane
This procedure will prevent the accidental overwriting of existing set parameters.
To exclude a database from monitoring:
Select the SQL Server node in the left pane and select the Databases tab. All databases from the selected server will be listed in the right pane.
Uncheck the databases that should be excluded from monitoring.
- Review the Included databases and Excluded databases info boxes for the database status
Press the Save button to save changes
Alert setting – Besides setting the alert threshold values in the Metrics window, thresholds can be also set directly in the Alerts window for existing alerts.
The following image illustrates a situation in which there are potentially too many alerts. If the alerts don’t point to an underlying problem in system performance, then raising the alert threshold, may better calibrate the frequency of alerts, and reduce the incidents of false positives.
In a situation when numerous short spikes spawn excessive alerts, setting the Period time longer than duration of the spikes will suppress them
Q: When metrics are set for a group, will those settings will be applied to all instances?
A: Setting up metrics for one specific group will apply settings for all instances that belong to this specific group. Settings for other monitored instances and groups will not be changed.
Q: When settings are changed for one instance, will those settings affect parent group?
A: No, in that case settings will only be applied to this specific instance.
Q: Are all databases monitored by default or this needs to be set up on the first run?
A: Yes, by default all databases are included for monitoring and they can be excluded if needed.
Q: Will raising threshold values resolve problems with performance?
A: No, raising threshold values just suppresses alerts, it is not an indicator that there are no problems with server performance.
Q: How can alerts be deleted after issues are resolved?
A: To clear alerts, select the adequate check box in front of the alert and click Apply in the yellow notification at the top.