Synchronous vs Asynchronous Mirror : Transaction Delay

by Snehashish Ghosh

If there is a need to do a comparative study between performance of the database server in Synchronous Mirror and  while in Asynchronous Mirror, the SQLServer counter Transaction delay should be captured and analysed.

Transaction Delay: Delay (in milliseconds) in waiting for commit acknowledgement from the mirror. This counters reports the total delay for all the transactions in process at that time. 

When running in Asynchronous mirroring the Transaction Delay counter will always be 0.

Find Transaction delay in Synchronous Mirror

 By comparing the counter value between a defined period,say 2 consecutive days, we could see how much of database time is spent in milliseconds to get commit acknowledge from Mirror Server. 

 

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

*