DBMIRRORING_CMD

Description

For databases using mirroring. This wait type accumulates while SQL Server is waiting for transaction log records to be flushed to disk. High values are expected but if this is experienced along side extended mirror latencies then investigation is required. Please note that database mirroring is a deprecated feature and could be removed in an upcoming release. Investigation into other high availability and disaster recovery solutions is recommended

Resolved by

DBAs and Developers

Suggested solutions

  1. If transactions on the principal are being delayed (because of high waits) consider switching the mirror mode to asynchronous
  2. Use Windows Performance Monitor to check network latency and whether the connection is over-utilised
  3. Ensure network devices have been configured correctly
  4. Consolidate transactions from row-by-row statements to batch processing. Batch processing generate less messages
  5. Check the performance of the disks hosting the data and transaction log files
  6. Unnecessary index maintenance must be sent across to the mirror (unnecessary messages). Remove any unused indexes from the principal

Additional research

Troubleshoot Database Mirroring Configuration
Database Mirroring Best Practices and Performance Considerations?

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index