Post reply

SQL Wait Statistics

  • June 5, 2013 at 5:09 am

    #294145

    Hi All

    I am troubleshooting an intermittent performance issue on a production SQL Server

    I checked wait stats and SQLTRACE_INCREMENTAL_FLUSH_SLEEP is at the top of the list

    Is this something I should investigate further or is it just showing up because I have default trace enabled?

    Thanks

  • June 5, 2013 at 5:16 am

    #1621291

    Ignore it. It's a sleep wait, meaning it's logged because some process is sleeping.

    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

  • June 5, 2013 at 5:19 am

    #1621293

    Thanks

    Will add it into my where wait_type not in() list

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

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