Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

using performance counter for monitoring db mirroring Expand / Collapse
Posted Sunday, September 8, 2013 11:51 AM


Group: General Forum Members
Last Login: Monday, March 21, 2016 11:37 AM
Points: 187, Visits: 394
I used high availability synchronous mode for db mirroring.I used one single box for doing db mirroring across three sql instances for principal,mirror and witness server.It worked fine,no issues.
When I went to check some of the counters on mirror instance from my perfmon it did not show any activity at all.Althogh the snapshot creataed against mirror db showed updated records but mirror counters such as Sql server:sql2k8:database mirroring log bytes received/sec and many mirror related counters,no activity was seen.what could be the problem?can anyone explain.
Post #1492609
Posted Monday, September 9, 2013 4:07 AM



Group: General Forum Members
Last Login: Yesterday @ 12:29 PM
Points: 17,173, Visits: 32,140
Yeah, you have to do a little work to see the activity in the performance metrics. I outline it in an article here.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1492720
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse