Post reply

Need help to understand these wait-types

  • June 26, 2014 at 8:18 am

    #295907

    I have SQL 2008 R2, I see top ten cumulative wait events.

    Could you please which ones I need to be concerned about,

    I have attached the spread sheet with results, If ideal situation can be explained much appreciated,

    Regards,

    Bubby

  • June 26, 2014 at 8:24 am

    #1725108

    I would start with this blog [/url]post by Paul Randal.


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • June 26, 2014 at 8:29 am

    #1725113

    Can I get a link please

  • June 26, 2014 at 8:39 am

    #1725120

    Click on the word blog it is a link


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • June 26, 2014 at 8:47 am

    #1725125

    Keith Tate (6/26/2014)

    I would start with this blog [/url]post by Paul Randal.

    just making the link look obvious.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • June 26, 2014 at 8:51 am

    #1725129

    FWIW, looking at your waits, only 2 stand out.

    CXPACKET and WRITE_COMPLETION

    You can search on those. But without information about IO load or your disk subsystem I won't comment yet on the write_completion.

    CXPACKET could mean you have poor performing indexes. It could mean that you have a CPU bottleneck. It could be benign. It depends on your workload.

    But based on the percent_total_waits, none of these indicate a problem.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 6 posts - 1 through 5 (of 5 total)

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