Database Mirroring History

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Database Mirroring History

Database Mirroring History

Rate Topic

Display Mode

Topic Options

Author

Message

SQLStudent7

Posted Wednesday, June 09, 2010 7:34 AM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 3:38 AM
Points: 9, Visits: 359

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

Post #934598

chris.mcgowan

Posted Tuesday, May 31, 2011 10:27 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 7:31 AM
Points: 1,791, Visits: 418

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
------------------------

Post #1117558

bradphilp

Posted Wednesday, October 31, 2012 8:42 PM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 7:24 PM
Points: 3, Visits: 28

msdb.dbo.dbm_monitor_data

Post #1379588

« Prev Topic | Next Topic »

Permissions