The Mirrored Server Role Change alert indicates when the role of a mirrored database changes.

When you configure this alert, you can set the time at which the alert resets. Reset this alert when the role of the mirrored database has no impact.

This alert is raised based on the diagnostic data collection interval specified in Server Properties. For more information, see Set general server options.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >