How to kill long running Queries Automatically

• azhar.iqbal499

  SSCrazy

  Points: 2812

  More actions

  May 19, 2011 at 6:52 am

  #236574

  Some time my Live server become too busy and give no response because of long running queries and LCK_M_S,LCK_M_IX waits are common.

  I want to kill those processes(sessions IDs) automatically that are taking time more than 30 min . Any other method to overcome these wait types.

  Thanks in Advance.

  Azhar

• gsc_dba

  SSCertifiable

  Points: 5407

  More actions

  May 19, 2011 at 8:13 am

  #1327097

  You may want to find out what and why they are taking so long but try: http://www.sqlservercentral.com/Forums/Topic193509-5-1.aspx#bm193857

  gsc_dba

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  May 19, 2011 at 8:15 am

  #1327100

  The real solution is to tune those processes and if possible run them of hours to lighten the load.

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/