Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

closed as unclear what you're asking by Max Vernon, Mark Storey-Smith, Michael - sqlbot, Paul White, dezso Nov 12 '13 at 22:08

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.