One fine morning, users started complaining my SQL server instance performance…They sent me a screenshot which indirectly says, their queries have timed out. I quickly logged in and checked if there are any blocks.
WHERE blocked <> 0
There were several blocks caused by a naughty spid 80.
When I checked DBCC INPUTBUFFER(80), To my surprise, I got below scary result.