Page History
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:
Info |
---|
The alerts are listed by default as Rank and categories. The default Ranks are classified as follows:
|
Category: Amazon RDS
Metric | Rank |
---|---|
100 | |
CPU Credit balance Low | 100 |
100 | |
100 | |
100 | |
Read Latency Low | 100 |
100 | |
100 | |
100 | |
Write Latency Low | 100 |
100 |
Category: Azure DB
Metric | Rank |
---|---|
100 | |
100 | |
100 | |
Average Log Write Percent Low | 100 |
100 | |
Database Average Memory Usage Percent Low | 100 |
100 | |
In-Memory Storage Usage Percent Low | 100 |
100 | |
Max Session Percent Low | 100 |
Max Worker Percent High | 100 |
100 | |
100 |
Category: Backup
Metric | Rank |
---|---|
40 |
Category: Databases
Metric | Rank |
---|---|
20 | |
...
...
...
20 | |
20 | |
10 | |
20 | |
...
20 | |
70 | |
30 | |
30 | |
30 | |
...
...
...
70 | |
70 | |
30 | |
30 | |
30 | |
30 | |
30 | |
30 | |
30 | |
30 | |
30 | |
30 | |
...
30 | |
80 | |
70 | |
20 | |
30 | |
30 |
Category: Logs
Metric | Rank |
---|---|
40 | |
40 |
Category: Operational
Metric | Rank |
---|---|
90 | |
90 | |
90 | |
50 | |
30 | |
30 | |
90 | |
50 |
Category: Queries
Metric | Rank |
---|---|
80 |
Category: Resources
Metric | Rank |
---|---|
20 | |
20 | |
20 | |
60 | |
60 | |
60 | |
...
20 | |
60 | |
20 | |
20 | |
60 | |
60 | |
...
20 | |
60 | |
60 | |
20 | |
20 | |
60 | |
60 | |
...
Category: Services
Metric | Rank |
---|---|
10 | |
10 | |
40 | |
10 | |
50 | |
50 | |
40 |
...
50 | |
80 | |
...
40 | |
80 | |
80 | |
...
...
Category: Sessions
Metric | Rank |
---|---|
40 | |
40 | |
60 | |
80 | |
40 | |
80 | |
...
...
...
20 |
Category: Virtualization
Metric | Rank |
---|---|
20 | |
20 | |
20 | |
20 |
...
20 | |
20 | |
20 | |
20 | |
20 | |
20 | |
20 | |
20 | |
...
20 |
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...