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 7:50 pm

    #1614041

    GilaMonster (5/9/2013)

    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.

    Hmmm... now I see your point.

    Let me play a bit with resource governor. But something it is clear to me, I do not want to limit or affect other users or clients, which shares the same instance, so need to test this carefully.