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

monitoring database mirroring and replication issues Expand / Collapse
Author
Message
Posted Wednesday, June 8, 2011 12:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 6, 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
Posted Monday, June 27, 2011 1:45 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 10, 2014 9:36 AM
Points: 1,414, Visits: 4,544
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 »

Add to briefcase

Permissions Expand / Collapse