Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Mirroring History Expand / Collapse
Author
Message
Posted Wednesday, June 9, 2010 7:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, May 31, 2014 8:00 AM
Points: 9, Visits: 422
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
Posted Tuesday, May 31, 2011 10:27 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, October 17, 2014 5:11 AM
Points: 1,797, Visits: 492
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
Posted Wednesday, October 31, 2012 8:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 12:13 PM
Points: 5, Visits: 53
msdb.dbo.dbm_monitor_data
Post #1379588
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse