The Alerts view allows you to view all alerts for all of the servers in your organization. You can organize the alerts in the list using either the Current View or the Filter.
The Change column is a useful way to see the agent history of a metric. This column tracks every status change occurring between OK, informational, warning, and critical states.
Access the Alerts view
You can open the Alerts view from the SQLdm Console by clicking Alerts in the Navigation pane.
Organize your alerts by the Current View
You can organize your alerts by selecting one of the following views from the Current View section of the Navigation Pane:
Organizes all your alerts that are currently active.
Organizes all your alerts by their severity.
Organizes all your alerts by monitored SQL Server instance.
Organizes all your alerts by each of the metrics affected.
Agent Job Failures
Lists all the alerts caused by Agent Job failures.
Lists all the alerts caused by blocked processes.
Oldest Open Transactions
Lists the oldest open transactions that have alerts associated with them.
Lists all the alerts associated with the Query Monitor.
Lists all the alerts associated with table reorganization.
Allows you to configure the view to show what is most important to you.
Organize your alerts using the Filter
SQL Diagnostic Manager allows you to organize your alerts using the available filter options. Click the Show Filter Options/Hide Filter Options toggle in the Navigation Pane to open the Alerts filter. Filter options such as the specific view, SQL Server instance, metric, severity, and time range associated with the alert help pinpoint to data you want to view.
You can also filter alerts based on the assigned.