Version Agnostic Management Pack which will monitor SQL Mirroring on SQL 2012, 2014, 2016, 2017, and 2019.
Read More...
SQL mirroring has been deprecated, in favor of using Always On. However, as customers migrated to the SQL Server Version Agnostic Management pack for monitoring SQL DB engines, they discovered that Microsoft did not include SQL mirroring in that MP. As an addendum – I used the SQL 2016 Mirroring management pack as a foundation, and re-architected it to discover and monitor SQL mirroring databases and witnesses on SQL 2012+, in conjunction with the SQL Version Agnostic MP for DB Engines.
The Folder is integrated in the root folder for the SQL Management Pack:
![](/ContentLibrary/SQL Server DB Mirroring Version Agnostic Management Pack/img/image-30.png)
Objects discovered:
- Mirrored Database
- Mirror Witness
- Mirror Group
![](/ContentLibrary/SQL Server DB Mirroring Version Agnostic Management Pack/img/image-31.png)
![](/ContentLibrary/SQL Server DB Mirroring Version Agnostic Management Pack/img/image-32.png)
Monitoring:
- Mirroring Synchronization Status
- Witness Status
- Partner State Status
The Database Mirror status monitor configuration:
![](/ContentLibrary/SQL Server DB Mirroring Version Agnostic Management Pack/img/image-33.png)
Witness monitor:
![](/ContentLibrary/SQL Server DB Mirroring Version Agnostic Management Pack/img/image-34.png)