Through below query you are able to find out blocking on SQL Server. It provides you details information about blocking queries in SQL Server Databases.
SELECT er.session_id , host_name , program_name , original_login_name , er.reads ,er.writes ,er.cpu_time , wait_type , wait_time , wait_resource ,blocking_session_id , st.text FROM sys.dm_exec_sessions es LEFT JOIN sys.dm_exec_requests er ON er.session_id = es.session_id OUTER APPLY sys.dm_exec_sql_text(er.sql_handle) st WHERE blocking_session_id > 0 UNION SELECT es.session_id , host_name , program_name , original_login_name ,es.reads , es.writes , es.cpu_time , wait_type , wait_time ,wait_resource , blocking_session_id , st.text FROM sys.dm_exec_sessions es LEFT JOIN sys.dm_exec_requests er ON er.session_id = es.session_id OUTER APPLY sys.dm_exec_sql_text(er.sql_handle) st WHERE es.session_id IN ( SELECT blocking_session_id FROM sys.dm_exec_requests WHERE blocking_session_id > 0 )
After the execution of above script you will get the output like below:-
