The Error Log Medium Severity alert notifies you when its configured condition is met on SQL Server instances so you can investigate and respond.
Mini DBA describes this alert as: Errors in the Sql Server error log of severity 15 or 16 These levels of severity covers user correctable errors such as problems with High Availability Groups or queries that throw errors Mini DBA evaluates this alert once a minute so changes are detected quickly.
This alert surfaces new SQL Server error-log entries at the configured severity so engine, availability, resource, and user-correctable errors are investigated with their actual message and context.
Enable it on production and shared SQL Server instances. Route high-severity entries urgently, and tune medium-severity routing only after reviewing the error numbers and workload context that recur in the environment.
This alert is based on a state or event rather than a numeric threshold. Tune its schedule, scope, severity, and notification route so that the response matches the importance of the instance.
Open the exact SQL Server error-log entry, capture its error number, severity, state, timestamp, and surrounding messages, then follow the response for that specific condition. Check related availability, storage, job, and application evidence instead of treating the log itself as a disk-capacity problem.
Tune routing by error number, recurrence, and business impact rather than suppressing the whole error-log alert. Preserve visibility for new or high-severity errors even when a known benign message is handled separately.