Page History
...
In addition to setting the thresholds for specific alerts, you can customize your alerts by adding comments to each alert. Comments allow you to include instructions to users when a level reaches a particular threshold or to provide additional information about the alert. You can also customize the levels at which SQL Diagnostic Manager provides alert notifications by changing the informational, warning, and critical values either on the Configuration tab of the Alert Configuration window or, for the database- and disk-level alerts, on the Database Threshold Configuration window available by selecting the database or disk , and clicking Edit.
You can also base your alerts on the past performance of the metrics collected by SQL Diagnostic Manager. This is a powerful and effective way to make sure that the alerts you receive are outside of your typical metric ranges.
...
- Right-click a SQL Server instance in the Servers sidebar.
- Select Configure Alerts.
- Select the metric you want to edit from the list in the Alert Configuration window.
- If the metric features a per-database or per-disk alert, on the Configuration tab of the Alert Configuration window, click Add. Use the drop-down list to select the database or disk to which you want to apply these settings. If the metric applies at the instance level, continue with the next step.
- Check the boxes next to Informational, Warning, and Critical to include alerts for these states.
- Change the alert thresholds by moving the arrows to the appropriate levels or by double-clicking the value and typing a new threshold level.
- If the metric features a per-database or per-disk alert, click Advanced to apply any advanced settings, such as alert suppression or autogrow settings. Click OK. If the metric applies at the instance level, continue with the next step.
- Select the Comments tab and enter the information you want displayed to display in the alert message for this metric.
- Click Apply.
- If you want to replicate these edits to other SQL Server instance SQL Diagnostic Manager is monitoring, tags, or templates, click Yes.
- Click OK to accept your changes.
...
A full refresh of alerts excluding table fragmentation occurs in the following circumstances even if longer collection intervals are defined:
- when When the collection service starts
- when When the collection service receives a new workload, such as redirecting the Management Service to a new Repository
- when When you add a SQL Server SQL Server for collection
- when When a SQL Server SQL Server resumes from Maintenance Mode
- when When a user selects Refresh Alerts
...