Check mirroring status from mirroring monitor in SQL Server

Check mirroring status from mirroring monitor in SQL Server

Mirroring is one of the best and easy to maintain high availability feature as long as SQL Server version is 2008 R2 or earlier. I wrote article about how to set certificate mirroring in SQL Server sometime back. Once you setup mirroring, you have to keep your eyes open about the status of mirroring whether it is “Synchronized” or still in “Synchronizing” mode, status is on or off etc.

SQL Server providing one powerful tool to keep watch on mirroring status, named “Mirroring Monitor” which you can ope from pop-up menu come from right click on Principal/Mirror database. Have a look at following screen capture for further information.

Once you click on “Launch Database Mirroring Monitor”, you have to add your server in the monitor and it will look like following screen capture:

This monitor will provide you with important information like send rate, restore rate, commit overhead etc along-with whether you principal and mirror and completely synchronized or still synchronizing.

If you like this article, do like “Extreme-Advice” page in Facebook.

Reference: Ritesh Shah

http://Extreme-Advice.com

http://www.sqlhub.com

Note: Microsoft Books online is a default reference of all articles.

Author: Riteshshah

Ritesh Shah is a database professional with having 16+ years of experience in various domain of IT field. He is a author of many technical articles on Microsoft Technology and authored a book of SQL Server 2012 Performance Tuning cookbook. He loves work with different Microsoft Products.

2 thoughts on “Check mirroring status from mirroring monitor in SQL Server”

Comments are closed.