locked
What effects Mirroring? RRS feed

  • Question

  • We are seeing lot of performance counters problems between our 2 data centers. The bandwidth is ~20 Mbps between our 2 data center. Could someone please explain me as how mirroring works on high bandwidth, high latency networks?

    These performance counters have out of range values

    MachineName

    ObjectName

    InstanceName

    CounterName

    CounterValue

    MinValue

    MaxValue

    \\A-db

    SQLServer:Database Mirroring

    A

    Log Send Queue KB

    114889

    50000

     

    Sunday, February 13, 2011 5:30 AM

Answers

  • http://technet.microsoft.com/en-us/library/cc917681.aspx
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, February 13, 2011 9:31 AM
  • What is "high latency" in your scenario? We do a lot of cross DC mirroring and have not encountered any major problems so far. And the send queue you described also does not necessarily mean that you have a problem. It very much depends on the new transaction rate...

     

    Tuesday, February 15, 2011 7:16 AM

All replies