SQL Server, Database Mirroring Object
The SQLServer:Database Mirroring performance object contains performance counters that report information about SQL Server database mirroring. The table below lists the counters that this object contains.
The table below lists the counters that this object contains.
| Name | Description |
|---|---|
Bytes Received/Sec |
Number of bytes received per second. |
Bytes Sent/sec |
Number of bytes sent per second. |
Log Bytes Received/sec |
Number of bytes of log received per second. |
Log Bytes Sent/sec |
Number of bytes of log sent per second. |
Log Send Queue |
Total number of bytes of log that have not yet been sent to the mirror server. |
Pages Sent/sec |
Number of pages sent per second. |
Receives/sec |
Number of mirroring messages received per second. |
Redo Bytes/sec |
Number of bytes of log rolled forward on the mirror database per second. |
Redo Queue |
Total number of bytes of hardened log that currently remain to be applied to the mirror database to roll it forward. This is sent to the Principal from the Mirror. |
Sends/sec |
Number of mirroring messages sent per second. |
Transaction Delay |
Delay in waiting for unterminated commit acknowledgement. |
Note
On each partner, some of the counters show a zero value depending on what role the partner is currently performing.
Remarks
The performance counters let you monitor database mirroring performance. For example, you can examine the Transaction Delay counter to see if database mirroring is impacting performance on the principal server, you can examine the Redo Queue and Log Send Queue counters to see how well the mirror database is keeping up with the principal database. You can examine the Log Bytes Sent/sec counter to monitor the amount of log sent per second.
See Also
Other Resources
Monitoring Resource Usage (System Monitor)