Home Forums SQL Server 2008 SQL Server 2008 Administration How can I kill ad-hoc or long time running queries, safely? RE: How can I kill ad-hoc or long time running queries, safely?

  • May 9, 2013 at 4:47 pm

    #1614021

    sql-lover (5/9/2013)

    Killing those ad-hoc queries after X minutes will release the IO pressure. So instead of hammering the SAN for 5+ minutes, if they are not done my 1 min or less , they will be killed.

    then the user will re-run the query and it'll hammer the SAN for another minute, be killed, be re-run, be killed, repeat until the user gets fed up and complains to management that they can't do their work.

    You're addressing the symptoms, not the problem.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass