title: what can cause sql server lock:cancel
body: <p>I am doing a sql server profiler on deadlocks because users are getting query time outs. In the profiler the eventClass column shows Lock:Escalation and Lock:Cancel.  How do I find out what would cause a query to be canceled?  Basically the same queries are being run by bunch of users and things zoom right through, but off and on throughout the day users are timing out. I am run sqldiag also; however, unfortunately I am not DBA and muddling my way through to discover the problem. Any suggestions?</p>
  
  <p>thanks community
  nick</p>