title: How to Terminate or Kill Suspended Task Automatically in SQL Server 2012?
body: <p>How we can terminate or kill the suspended task automatically in SQL Server 2012? When I run <code>sp_who2</code> then it shows many process in a <code>Suspended</code> state.</p>
  
  <p>I want to know that is there any way that we can terminate or kill the suspended process/task automatically rather than doing manually. </p>
  
  <p>I know how to kill the <code>SPID</code> manually but I want something which can automatically kill those tasks after a defined amount of time.</p>
  
  <p>Any help will be appreciated.</p>