identifie blocking process

/*BLOCKING*/
EXEC dbo.sp_WhoIsActive @find_block_leaders =1,
@output_column_list ='[blocked_session_count][blocking_session_id][session_id][CPU][status][wait_info]
                      [database_name][sql_text][host_name][open_tran_count]',
@sort_order='[blocked_session_count]DESC'

Use Adam's great procedure

Who Is Active? v10.00 (2010-10-21)
(C) 2007-2010, Adam Machanic


Updates: http://ift.tt/VRLyoN
"Beta" Builds: http://ift.tt/1IiYsZU

License: 
Who is Active? is free to download and use for personal, educational, and internal 
corporate purposes, provided that this header is preserved. Redistribution or sale 
of Who is Active?, in whole or in part, is prohibited without the author's express 
written consent.

---

Best Regards,Uri Dimant SQL Server MVP, http://ift.tt/1iQ9JkR

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence