Some time my Live server become too busy and give no response because of long running queries and LCK_M_S,LCK_M_IX waits are common.
I want to kill those processes(sessions IDs) automatically that are taking time more than 30 min . Any other method to overcome these wait types.
Thanks in Advance.
Azhar