SQL Server Performance

database mirroring perforcance counter

Discussion in 'SQL Server 2005 Database Mirroring' started by dmaddhali, Dec 12, 2005.

  1. dmaddhali New Member

    I would like to monitor all the performance counter intormation related to database mirroring.there are sys tables which has information related to messages/data/log sent.
    I dont want to use perfmon.exe in windows. I want to use performance counters to get this information programtically in sql server 2005 / visual c++ 2005

    I would like to use the performance counters to get :

    Bytes Received/Sec : Number of bytes received per second.

    Bytes Sent/sec : Number of bytes sent per second.

    Log Bytes Received/sec: Number of bytes of log received per second.

    Log Bytes Sent/sec : Number of bytes of log sent per second.

    Log Send Queue : Total number of bytes of log that have not yet been sent to the mirror server.

    Pages Sent/sec : Number of pages sent per second.

    Receives/sec : Number of mirroring messages received per second.

    Redo Bytes/sec : Number of bytes of log rolled forward on the mirror database per second.

    Redo Queue : Total number of bytes of hardened log that currently remain to be applied to the mirror database to roll it forward. This is sent to the Principal from the Mirror.

    Sends/sec : Number of mirroring messages sent per second.

    Transaction Delay : Delay in waiting for unterminated commit acknowledgement.

  2. mulhall New Member

    Have you tried tracing?
  3. satya Moderator

Share This Page