Home Forums SQL Server 2008 SQL Server 2008 - General Blocked Threads RE: Blocked Threads
Ant-Green
SSC Guru
Points: 113445
More actions
June 13, 2012 at 8:48 am
#1500423
First find out what SPID63 is doing, is it inside a transaction which hasnt been committed
select * from sys.dm_exec_requests
cross apply sys.dm_exec_sql_text(sql_handle)
cross apply sys.dm_exec_query_plan(plan_handle)
where session_id = 63
http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ chapter 6