monitoring database mirroring and replication issues

• shenkar.g

  SSC Veteran

  Points: 212

  More actions

  June 8, 2011 at 12:53 am

  #241827

  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

• alen teplitsky

  SSC-Dedicated

  Points: 30014

  More actions

  June 27, 2011 at 1:45 pm

  #1344782

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