SQL Server 2005 – Blocked process report

In SQL Server 2000 and earlier version, there was no easy way to find blocking on server. You need to capture Blocker script and do analysis. Going forward, in SQL Server 2005 there is new event in profier trace called “Blocked Process Report” Event Class. I have seen questions like why this is not getting generated….

1