0

I have four mirrored user DB's on a pair of Server 2008 R2 machines. My Db engine is SQL Server 2008. Of the four Db's one is warning me of overhead commit latencies ( > 20ms). From some research on the web I see many references of a "redo queue".

I was hoping some one could explain to me what is a redo queue and how can I monitor its behavior.

1
  • How is your mirroring configured - synchronous or async ?
    – Kin Shah
    Jun 1, 2015 at 13:50

1 Answer 1

1

Using performance monitor in windows you can for example watch the redo queue. Also any other db monitoring tool would help.

The next sentence explains the redo queue, since I can't do it better than msdn here the quote: "The mirror server immediately writes the incoming log to disk, where it is held until it is applied to the mirror database. The log waiting on the mirror's disk is known as the redo queue."

( https://technet.microsoft.com/en-us/library/ms189901%28v=sql.105%29.aspx )

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.