How to check blocking queries in SQL Server
<p>I have one warehouse server which got data/sync from legacy system 24/7, I noticed some of my reports/sql jobs performance is uncertain and most of the time I heard from DBA team that my <strong>query is blocking</strong> to other sync process.</p>

<p>From DBA team I came to know command i.e. EXEC SP_WHO2 by which I can identify spid of query which cause blocking by looking into column BlkBy.</p>

<p>Please suggest me how I can avoid blocking and other ways to check <strong>blocking</strong> in <strong>SQL Server</strong></p>