Post reply

What is the impact of running 'sys.dm_os_wait_stats', CLEAR on production server

  • February 24, 2015 at 3:38 pm

    #298036

    Is there any impact running 'sys.dm_os_wait_stats', CLEAR on production? Thanks

  • February 25, 2015 at 1:52 am

    #1779815

    No impact, though if you have monitoring tools looking at the wait stats they may get confused.

    Personally I prefer not to clear it when doing analysis and just take diffs of the values.

    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

  • February 25, 2015 at 5:35 am

    #1779867

    Just a plus one to what Gail said. Better to capture diffs so you still have the accumulated values.

    BTW, running it doesn't hurt, but if you ran it over and over and over, it might. Nothing is ever free.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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