using performance counter for monitoring db mirroring

  • 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.

  • Yeah, you have to do a little work to see the activity in the performance metrics. I outline it in an article here[/url].

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply