seven1m · March 17, 2010 16:59
diff --git a/gistfile1.txt b/gistfile1.txt
 # I don't pretend to understand this query,
 # but it seems to be a good list of processes
 # that are "blocking" other processes and hosing the server.

 select * from sys.dm_os_waiting_tasks where session_id != @@spid and session_id > 50 and blocking_session_id < session_id order by wait_duration_ms desc;
	# I don't pretend to understand this query,
	# but it seems to be a good list of processes
	# that are "blocking" other processes and hosing the server.

	select * from sys.dm_os_waiting_tasks where session_id != @@spid and session_id > 50 and blocking_session_id < session_id order by wait_duration_ms desc;