locked
Database Mirroring Monitor - Where is it populated from? RRS feed

  • Question

  • I know connections are made to both the Principle and Subscriber but how/where are the metrics gatherered from?

    Are there system tables that can be looked at OR is the monitor pulling the info from the portion of the TLog that is needing to be mirrored so that both side are in sync (or as close to sycned as possible)?

    Is the monitor just working with the portion of the TLog that was send to the subscriber to harden in and it has some type of application to keep up with how many KBs of the log need to be retored, time to restore log, current restore rate ...

    Thanks!

    Wednesday, March 10, 2010 7:50 PM

Answers

  • Hi ,

     

    I think the database mirror monitor fetches out data from the msdb stored procedure sp_dbmmonitorresults and that SP uses table msdb.dbo.dbm_monitor_data . But it seems like the table reads the portion of transaction logfiles and stores those data in them.


    Thanks, Leks
    Wednesday, March 10, 2010 9:09 PM
    Answerer