Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, October 19, 2014 12:25 AM
Points: 135, Visits: 264
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 13,876, Visits: 28,274
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

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

Add to briefcase

Permissions Expand / Collapse