How to bring write log wait type count down.

  • This is the scenarion in my environment

    WaitType Wait_Sec Resource_Sec Signal_Sec Wait Count Wait Percentage

    WRITELOG920039.89887485.89 32554.00 23446032975.02

  • Reducing WRITELOG wait[/url]

    Gerald Britton, Pluralsight courses

  • ensure your logs are sized appropriately and make sure they're segregated to fast disks would be a start

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Log file is used in sequentially . Unless first log is completely filled .Tranactions wont go to another log which is in other disk. so ho come it brings the write log count down. Please clariffy

  • Segregated from database files, not from other log files in the same database.

    John

  • In my environment .mdf files are in one drive and .ldf files are in another drive. we had tranactional replication in the instance where i am getting the performance issue.

  • m.rajesh.uk (10/30/2015)


    Log file is used in sequentially . Unless first log is completely filled .Tranactions wont go to another log which is in other disk. so ho come it brings the write log count down. Please clariffy

    not sure what you're referring to?

    Keep the number of transaction log VLFs to a minimum by appropriately sizing your transaction logs and separate the logs onto separate fast disks

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • m.rajesh.uk (10/30/2015)


    we had tranactional replication in the instance where i am getting the performance issue.

    I suppose if your Log Reader Agent is reading from the logs then access is no longer sequential and so you'd expect more WRITELOG waits. You might try reducing the frequency at which the Agent runs.

    John

  • Are the WRITELOG waits occurring throughout the day during normal operation of application or intermittedly during something like a batch load /delete or re-index?

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • WRITE Log is occurring through out the normal operation of application.

Viewing 10 posts - 1 through 9 (of 9 total)

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