Post reply

writelog wait_type sys.dm_os_wait_stats reasonable number

  • May 5, 2014 at 10:12 am

    #290967

    I found a simple query on the web to evaluate my waitstats for log writes.

    SELECT wait_time_ms

    FROM sys.dm_os_wait_stats

    WHERE wait_type = 'WRITELOG'

    I am not having a performance issue but I noticed the results for the above query were in the millions of mili seconds.

    What is a reasonable number for writelog waitstats and am I missing something obvious?

    thanks

    David

  • May 5, 2014 at 11:32 am

    #1710813

    You have to keep in mind that this value is an accumulation since the last server restart, so if your server has been up for months a wait time in the millions isn't that much. I've got a server that's been up since December and the WRITELOG wait is over 6 million but that is only about 0.06% of the time the server has been up. You'd be better off looking at the % of total waits that WRITELOG is using.

    Also a reasonable number for your system may not be a reasonable number for someone else's. You need a baseline and then you can find what is not reasonable (normal). If my logs are on SSD's and your's are on 7500RPM spinning disks, your number is not what I should be getting.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

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

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