question

Troy_2012 avatar image
Troy_2012 asked

what counters we should monitor on the principal & mirror

Hi, I read that we should monitor some counters in principal and mirror Server like:- -Bytes Sent/sec: -Log Send Queue KB: -Pages Sent/sec: SQL2008 , Win2008 Enterprise. q1-When I opened the reliability and Performance monitor in WinServer 2008 I couldn't find these counters q2-Do we need more counters anyone can suggest it. q3-How can we read or use these counters in the work.
sql-server-2008mirroring
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered
These should appear under the SQLSERVER:Database Mirroring object. ![See attached][1] [1]: /storage/temp/507-add+counters_2012-12-03_17-16-26.jpg

2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Troy_2012 avatar image Troy_2012 commented ·
what about :- -Logical Disk Disk Write Bytes/sec -SQL Server: Databases Log Bytes Flushed/sec -SQL Server: Databases Transactions/sec
0 Likes 0 ·
ramesh 1 avatar image ramesh 1 commented ·
agreed with Jonlee
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.