Getting Wait Stats

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 716639

    Comments posted to this topic are about the item Getting Wait Stats

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71492

    Nice question to get the grey matter firing after a weekend, thanks, Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • Me_XMan

    Newbie

    Points: 1

    Just woke up and answered it wrong. I didn't have any coffee yet.

  • Jeff Moden

    SSC Guru

    Points: 995148

    Someone should do a survey that asks if anyone has actually been successful in using this DMV to actually find and fix performance issues or if they use other methods to initially detect a performance issue and what to look for.

    I cannot speak for others but I've never used this DMV to troubleshoot performance and don't actually know anyone that has, successfully.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

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

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