SQL Server Performance Forum – Threads Archive
database mirroring perforcance counterI 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.
Have you tried tracing?
For your joy. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.