Mirroring Monitoring
This metric category provides information about a database mirroring session. You must launch the Microsoft Database Mirroring Monitor tool before this metric category can collect data. If you are not using Mirroring, the Mirroring Monitoring metrics will be disabled by default. If at a later date you enable Mirroring, you will need to run the following command on the Agent that hosts the plugin to enable the metrics:
emctl reload agent dynamicproperties <Target_name>:microsoft_sqlserver_database
Table 2-52 Mirroring Monitoring Metrics
Metric | Description |
---|---|
Database Name |
Name of the database. |
Mirroring Role |
Current role that the database plays in the database mirroring session. |
Mirroring State |
State of the mirror database and the database mirroring session. |
Witness Status |
Status of the witness in the database mirroring session. |
Log Generation Rate (KB) |
Rate of log generation in KB/s. |
Unsent Log (KB) |
Amount of unsent logs in KB. |
Send Rate (KB/s) |
Send rate in (KB/s) |
Unrestored Log (KB) |
Amount of unrestored logs in KB. |
Recovery Rate (KB/s) |
Recovery rate in KB/s |
Transaction Delay (ms) |
Length of a transaction delay in milliseconds |
Transactions per second |
Amount of transaction per second. |
Average Transaction Delay |
Average transaction delay. |
Mirroring Role Description |
Description of the mirroring role. |
Mirroring State Description |
Description of the mirroring state. |
Witness Status Description |
Description of the witness status. |