Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gail Shaw Stairway to Transaction Log Management in SQL Server, Level 9: Monitoring the Transaction Log RE: Stairway to Transaction Log Management in SQL Server, Level 9: Monitoring the Transaction Log

  • April 24, 2013 at 4:05 pm

    #1609745

    Paul Brewer (4/24/2013)

    WRITE_LOG operations, as a percentage of overall wait time statistics, went from 20% to 50% as a result of re-enabling SAN replication. There's a battery backed write cache on the SAN but Disk Queue Lengths are up a bit and other PERFMON counters show a negative impact. The system is coping with SAN Replication on but there is definitely a cost associated with it, mainly to log writes.

    I've had similar experiences

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass