SQL Server: Automatically Detect and Kill Long Running Processes

added by lionofdezert
9/5/2012 10:36:48 AM

0 Kicks, 120 Views

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 ;)