title: why query shows in suspended task state and LCK_M_X wait type
body: <p>I am working on winform application using C# 4.0, back end SQL SERVER 2012.
  Some time, my software seems to be hang, because queries become pending, because
  one query shows in activity monitor in suspended mode, 
  this suspended query is run successfully several time but some time this problem occurs.</p>
  
  <p>The activity monitor shows :</p>
  
  <p>Task State : Suspended</p>
  
  <p>command : Update</p>
  
  <p>Application : .net SqlClient Data Provider</p>
  
  <p>Wait time : 5673610..... (unlimited)</p>
  
  <p>Wait Type : LCK_M_X</p>
  
  <p>Wait Resource : keylock hobtid=72057594058768384 dbid=14 id=lock2dbc30880 mode=X associatedObjectId=72057594058768384</p>
  
  <p>What is the reason of a query state become suspended.</p>
  
  <p>how can i stop it to be suspended ? </p>