SQLDM Web Console allows you to view all the triggered alerts in a single view in your server's environment. To access this view go to the Alerts tab.
Monitor your alerts by status server
The Alerts tab gives you a summary of the number of servers and alerts of your SQL Server instances grouped by the status server. You can find the status server overview at the right top of the SQLDM Web Console.
Selecting one of the server status options allows you to filter your alerts. Each option represents a status server:
- All Servers
- Critical
- Warning
- Ok
- Maintenance
Organize your alerts
Your alerts are organized under the following columns:
- Severity - Organizes all your alerts by their severity (Severity 8, Severity 4, and Severity 1).
- Change
- Active - Organizes all your alerts that are currently active.
- Time
- FriendlyServerName
- Instance - Organizes all your alerts by monitored SQL Server instance.
- Server Type
- Summary
- Database
- Table name
- Details
- Metric - Organizes all your alerts by each of the metrics affected.
- Category - Organizes all your alerts by their category.
- SQLdmRepository - Organizes all your alerts by SQL Diagnostic Manager Repository.
- Advanced Filter
Severity
In the new Alert grid, Severity uses the following numerical values:
- Severity 8 = Critical
- Severity 4 = Warning
- Severity 1 = Informational
The Dashboard console has a new alert grid and custom filters that help you organize your alerts in your most convenient way. Click the icon located next to the column name to expand the drop down menu. This menu allows you to sort your criteria by Sort Ascending or Sort Descending, you can remove or add the Database, Category, and Show Details columns, and group the information by fields.
Additional options
- Access the single instance dashboard by clicking the instance name in an alert row.
- Access the Alerts Detail screen by clicking Show Details.
- Export your alerts information in different formats: Excel, CSV, and HTML.