Link Details

Link 844079 thumbnail
User 449508 avatar

By lionofdezert
via connectsql.blogspot.com
Published: Sep 06 2012 / 05:10

You can not stay login on production servers all the time to detect long running query, so how to detect long running processes and kill them automatically if they are exceeding a specific amount of time. As well as sending a mail to DBA team that how a process was creating problems, so it is killed ;)
  • 8
  • 0
  • 554
  • 295

Comments

Add your comment
User 1060481 avatar

mark1927 replied ago:

0 votes Vote down Vote up Reply

LIke it

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (8)



Voters Against This Link (0)



    Java EE7
    Written by: Andrew Lee Rubinger
    Featured Refcardz: Top Refcardz:
    1. Design Patterns
    2. OO JS
    3. Cont. Delivery
    4. CI Patterns
    5. CI Tools
    1. Spring Integration
    2. Git
    3. Regex
    4. Java
    5. REST