Monitoring a Mirrored Database Environment

After active mirroring has started, you can monitor the complete mirrored topology in a few ways. You can start by registering the database being mirrored to a new facility within SSMS called Database Mirroring Monitor. Database Mirroring Monitor allows you to monitor roles of the mirroring partnership (that is, principal, mirror, and witness), see the history of transactions flowing to the mirror server, see the status and speed of this transaction flow, and set thresholds to alert you if failures or other issues occur. In addition, you can administer the logins/service accounts being used in the mirrored database topology.

Figure 41.17 shows how you launch the Database Mirroring Monitor from SSMS: ...

Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.