How to configure metric thresholds and baselines with SQL Diagnostic Manager for SQL Server

In SQL Diagnostic Manager, whenever a metric exceeds the configured value or threshold, the state of the metric changes and it can execute an alert or action. In SQL Diagnostic Manager, thresholds come pre-configured with industry-standard levels. This does not mean these levels are a one-fit-for-all solution for everyone. There are several attributes regarding thresholds in SQL Diagnostic Manager. First, when you select the instance configure alerts, you can have the option for configuring the thresholds. You can view the metrics that you can enable or disable, meaning that you can collect information about those metrics. You need not collect data you do not need or you do not want. The next feature is ranking, which is new in SQL Diagnostic Manager 10.5. It is basically an alert priority condition to only notify you of the most important alerts above a certain track. By default, they come with certain ranks. When you create an alert, you can specify that it only alerts on those metrics that rank above a certain threshold.

Watch the 18-minute video “Configuring Metric Thresholds and Baselines with SQL Diagnostic Manager for SQL Server to learn how to better alert to abnormalities while not alerting to normal situations for SQL Servers by quickly and easily configuring metric thresholds and baselines.