SQL Server Alerts

The SQL Server Alerts page shows alerts associated with a specific monitored SQL Server. Use it to focus triage on one instance instead of the whole estate.

What To Use It For

• Review active SQL Server issues.
• See recent alert history for the instance.
• Connect alert messages to the relevant SQL Server monitoring page.
• Confirm whether an alert has cleared after remediation.

Workflow

1. Open the SQL Server in the navigation tree.
2. Select Alerts.
3. Review severity, time, and message.
4. Open the relevant page such as Activity, Waits, Files, Always On, or Health Checks.
5. Use Configure and Copy Config to edit or copy alert policy.
6. Configure delivery from the global Alerts and settings pages.

How To Use SQL Server Alerts

SQL Server Alerts is the focused alert view for one monitored SQL Server instance. Use it during incidents, daily operations, and follow-up reviews when you already know which instance is affected. It reduces estate-wide noise and helps connect an alert to the relevant SQL Server monitoring page.

Start with alerts that are high severity, new, recurring, or close to the user-reported time. Then validate the evidence. Performance alerts may need SQL Server Activity, SQL Server Queries, or SQL Server Waits. Storage alerts should be compared with SQL Server Files and SQL Server Drives. Availability alerts may require SQL Server Always On and SQL Server Error Log.

For repeat issues, document the owner, action, and outcome rather than only acknowledging the alert.

Use Copy, Export, And Import Alert Configuration when this SQL Server should share thresholds, enabled states, custom alerts, and notification routing with another SQL Server or with a template server on another connected engine.

SQL Server Alert FAQ

Why use server alerts instead of global alerts?

Use this page for one instance. Use global Alerts for estate-wide triage and prioritization.

Can an alert prove root cause?

Usually no. Alerts identify conditions. Related monitoring pages provide the evidence needed for diagnosis.

What if the same alert repeats?

Check whether the threshold, workload, maintenance schedule, or unresolved root cause explains the recurrence.

Alert Type Reference

The following Mini DBA SQL Server alert detail pages explain why each alert is useful, when to enable it, how to tune thresholds, and what remediation steps to take when the alert is active. Custom Alert is included because each server Alerts page can also hold user-defined query alerts.

Related Pages

• Alerts
• Copy, Export, And Import Alert Configuration
• Alert recipients
• Recipient groups