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 09, 2010 7:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 7:58 AM
Points: 9, Visits: 419
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: 2 days ago @ 4:39 PM
Points: 1,797, Visits: 472
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: Monday, April 07, 2014 3:14 PM
Points: 5, Visits: 45
msdb.dbo.dbm_monitor_data
Post #1379588
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse