Lock request time-out period exceeded

Question

 

Hi ,

   i am getting error  Lock request time-out period exceeded frequently

 Could any one explain how can i track the Locking transactions

 SP_who,SP_lock helps me partially but i need clear solution

Answer 1

Have you tired using Profiler?  You have the ability to capture some information including locking information.  Here is a good Profiler resource:

 

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=Profiler&referringTitle=Home

Answer 2

Sp_who2 will show the bloker source and just kill the SPID

---

MLC