Check manual page of mssql_mirroring

MSSQL Database: Mirroring

Distribution Official part of Checkmk
License GPLv2
Supported Agents Windows
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 discovered.

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.

Parameters: 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 "SYNCHRONIZED".

"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 plugin.

Item

The database name.

Discovery

A seperate service is created for each database.