Waits and Queues

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738140

  More actions

  August 23, 2019 at 12:00 am

  #3670744

  Comments posted to this topic are about the item Waits and Queues

• erb2000

  SSCommitted

  Points: 1697

  More actions

  August 23, 2019 at 2:56 pm

  #3673981

  I wrote a little monitor program that queries the database every 30 seconds checking for blocking sql. Usually the query returns nothing. If it does return some data, the program records the info (including wait time and the sql causing the blocking). It maintains a history and checks if that same sql caused blocking before, and if so it updates the total count and blocking time.

  I found couple of sql queries that accounted for 99% of the blocking.