Mirroring - meassure log remaining

• kucyk

  Mr or Mrs. 500

  Points: 511

  More actions

  May 18, 2018 at 3:21 am

  #333763

  Hello,
  my mirror is curently down.
  I would like to count how many MB, transactions etc are awaiting to be sent if my
  2nd node will be available.

  I've also checked sys.dm_os_performance_counters but:
  Log Send Queue KB            
  Mirrored Write Transactions/sec           
  Log Remaining for Undo KB  

  those counters = 0

  I can't find a way to meassure how many data will be sent if my second node will be up.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737535

  More actions

  May 21, 2018 at 9:36 am

  #1991266

  And you have transactions occurring, right? I'd think the log send queue would have this. Most of the counters seem to be rates or mirror counters.

  I did see a note that this counter isn't always updated if the mirroring is paused.