I have a problem where users are reporting intermittent errors in an application that is using a SQL Server 2005 database. Nothing jumped out at me at first glance so I took a look at dm_os_ring_buffers. This led me to determine there are lock request time outs occurring on a table used by the application.
I've traced this back via Profiler to the SPIDs experiencing the blocking - both processes are system TASK MANAGER processes. Based on this I don't think this is causing my application errors but I want to be sure.
How can I proceed from here? Is this even likely to be causing an issue?
