Find root cause of blocking process on SQL Servers

In a SQL Server environment, if lots of processes are blocked, sometimes it is hard to find actual blocking process.

SYSTEM FUNCTION SYS.FN_TRACE_GETTABLE’S RESULT SET

To collect information about activities on SQL Server, SQL Profiler or server side trare is used. To start with profiler let’s set firts parameters as below.