Sergey Vavinskiy (9/21/2009)
Here are a couple a good strategies:
You can choose, do you want to know the process, or just catch it to investigte?
1. Traceon can cath your deadock info so you can investigate and maybe correct some bad coding.
2. get te SPID of the blocking process, and use it in DBCC INPUTBUFFER(spidid in here)
example:
DBCC INUTBUFFER(234)
Result will show the query running/was running..
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle