Post reply

Read response time Transaction Log

  • April 15, 2014 at 8:55 am

    #396607

    Hi

    We have poor performance spikes on a drive containing our log file but this is only for reads and seems to be at a time when we run a re-index job. Can anyone tell me if this is a likely correlation as to poor performance in reading the log file, and what reads are done from a log file. Any links provided would be gratefully received.

    Thanks

  • April 15, 2014 at 9:04 am

    #1706148

    During the time you are reindexing aren't you writing to the log file???

  • April 15, 2014 at 9:10 am

    #1706149

    Transactional replication, change data capture, mirroring, availability groups, log backups, full/diff backups, transaction rollbacks all read from the log.

    Could be the writes to the log from the rebuild have a negative impact on read throughput

    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

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

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