SQL Diagnostic Manager offers numerous alerts to successfully monitor and warn you about your SQL Server instances and availability groups. Proper configuration is key to making sure you receive alerts only on those metrics that actually fall outside the typical performance of your environment. SQL Diagnostic Manager includes the following metric alerts for your use:
The alerts are listed by default Ranks and categories. The default Ranks are classified as follows:
|
Metric | Rank |
---|---|
40 |
Metric | Rank |
---|---|
20 | |
20 | |
20 | |
10 | |
20 | |
20 | |
10 | |
20 | |
20 | |
70 | |
30 | |
30 | |
30 | |
30 | |
30 | |
30 | |
70 | |
70 | |
30 | |
30 | |
30 | |
30 | |
30 | |
30 | |
30 | |
30 | |
30 | |
30 | |
30 | |
80 | |
70 | |
20 | |
30 | |
30 |
Metric | Rank |
---|---|
100 | |
100 | |
100 | |
Average Log Write Percent Low | 100 |
100 | |
100 | |
100 | |
Database Average Memory Usage Percent Low | 100 |
100 | |
100 | |
In-Memory Storage Usage Percent Low | 100 |
100 | |
Max Session Percent Low | 100 |
Max Worker Percent High | 100 |
100 | |
100 | |
100 | |
100 | |
100 | |
100 | |
100 |
Metric | Rank |
---|---|
40 | |
40 |
Metric | Rank |
---|---|
90 | |
90 | |
90 | |
50 | |
30 | |
30 | |
90 | |
50 |
Metric | Rank |
---|---|
80 |
Metric | Rank |
---|---|
20 | |
20 | |
20 | |
60 | |
60 | |
60 | |
20 | |
60 | |
20 | |
20 | |
60 | |
60 | |
20 | |
60 | |
60 | |
20 | |
20 | |
60 | |
60 | |
20 | |
20 | |
20 |
Metric | Rank |
---|---|
10 | |
10 | |
40 | |
10 | |
50 | |
50 | |
40 | |
50 | |
80 | |
40 | |
80 | |
80 | |
10 | |
50 | |
10 | |
40 | |
80 |
Metric | Rank |
---|---|
40 | |
40 | |
60 | |
80 | |
40 | |
80 | |
40 | |
20 |
Metric | Rank |
---|---|
20 | |
20 | |
20 | |
20 | |
20 | |
20 | |
20 | |
20 | |
20 | |
20 | |
20 | |
20 | |
20 |
SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.| | | | | | | |