Home All Groups Group Topic Archive Search About

SQL to get redo queue size

Author
27 Jul 2006 1:56 PM
Kevin Jackson
Anyone know if it's possible to get the current size of the Redo Queue on a
mirrored database with SQL?  We create a snapshot 4 times a day for our
technical support department to query and if the redo queue is quite behind,
the snapshot takes a long time to create.  So we want to bypass creating the
snapshot if the redo queue is backed up over some threshold.

Thanks

AddThis Social Bookmark Button