monitoring database mirroring and replication issues

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Database Design » Disaster Recovery » monitoring database mirroring and replication...

monitoring database mirroring and replication issues

Rate Topic

Display Mode

Topic Options

Author

Message

shenkar.g

Posted Wednesday, June 08, 2011 12:53 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, September 06, 2011 12:03 AM
Points: 20, Visits: 93

Dear All,

Dear All,
I am working as Junior DBA in a banking domain , in our environment we have a database mirroring and replication and SQL version is 2005 with SP@. now this is big task for me .
Database mirroring is : high safety with witness server
Replication : transaction replication.
Please help me for the following topics :
How to me monitor the mirroring performance and failover.?
How to me monitor the mirroring performance and errors failover?

regards
-----------
shenkar gade

Post #1121540

alen teplitsky

Posted Monday, June 27, 2011 1:45 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:15 PM
Points: 1,409, Visits: 4,509

for replication you can use performance counters or one of the DMV's that return the number of transactions waiting to be replicated

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]

Post #1132431

« Prev Topic | Next Topic »

Permissions