Getting Wait Stats

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738043

  More actions

  June 10, 2019 at 12:00 am

  #3642096

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

• Stewart "Arturius" Campbell

  SSC Guru

  Points: 72715

  More actions

  June 10, 2019 at 8:06 am

  #3651720

  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

  More actions

  October 28, 2019 at 11:15 am

  #3692314

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

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  Follow

  October 28, 2019 at 6:09 pm

  #3692498

  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.

  Change is inevitable... Change for the better is not.
  

  ---

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