Home Forums SQL Server 2008 T-SQL (SS2K8) Possible to use tored proc to kill all queries running longer than 2 hours AND are blocking other queries RE: Possible to use tored proc to kill all queries running longer than 2 hours AND are blocking other queries

  • May 8, 2013 at 8:37 am

    #1613380

    GilaMonster (5/8/2013)

    Can you be a bit clearer what you want?

    Kill all the queries that have been running for 2 hours and have been blocking other queries for 2 hours?

    Kill all the queries that have been running for 2 hours and have blocked some queries at some point in that 2 hour period?

    Kill all the queries that have been running for 2 hours and are blocking other queries at the point that the query is checked?

    Something else?

    Kill all queries which has digit '2' in it ...

    The ones which have no digit 'two' better to be killed too!

    :hehe:

    I guess, OP should consider Jeff Moden suggestion...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]