Microsoft SQL Server 2005 Best Practices
Run the following script in the application database:
use AdventureWorks select * from sys.sysprocesses where blocked != 0