Database Mirroring History

• SQLStudent7

  SSC Veteran

  Points: 257

  More actions

  June 9, 2010 at 7:34 am

  #236273

  Hi All,

  Is it possible to extract the Database Mirroring History exactly as it is in the GUI Database Mirroring Monitor?

  I have queried some of the system tables in msdb like dbo.dbm_monitor_data but cannot find anything that has such attributes as Mirror Commit Overhead etc.

  Is there a view that I don't know about?

  Any assistance would be greatly appreciated

  Thanks in advance

• chris.mcgowan

  SSCarpal Tunnel

  Points: 4269

  More actions

  May 31, 2011 at 10:27 am

  #1332108

  I would be interested in the same sort of information for SQL Server 2008 R1.

  Thanks

  Chris

  ------------------------
  I am the master of my fate:
  I am the captain of my soul.
  ------------------------
  Blog: http://sqlserver365.blogspot.co.uk/
  Twitter: @ckwmcgowan
  ------------------------

• bradphilp

  Valued Member

  Points: 57

  More actions

  October 31, 2012 at 8:42 pm

  #1554826

  msdb.dbo.dbm_monitor_data