MSSQL Database: Mirroring
Mirroring is the practice of having two or more instances of the same database
on different servers to enable failover.
This check monitors the mirroring status of MSSQL databases that have
mirroring configured. Databases that do not have mirroring configured are not
Note: mirroring information is only shown as a service on the server that
hosts the principal database. It is NOT shown on any servers that host the
mirror databases. This is to avoid duplicate service states and alerts. We
therefore recommend to cluster these services.
This check is configurable via the "MSSQL Mirroring State" ruleset. The
following parameters can be configured:
"Mirroring state criticality":
Decide which criticality the service should have if the mirroring state is not
"Mirroring witness state criticality":
Decide which criticality the service should have if the mirroring witness
state is not "CONNECTED".
This check needs the Checkmk mssql.vbs-plugin installed on the host. Please
refer to the online documentation for instructions on how to install this
The database name.
A seperate service is created for each database.