LinkedIn | FaceBook | Twitter
At the server-level, I explained many of the reports dealing with transactions, and this report has much of the same information, but it is scoped to a single database. I often use the server reports to locate any issues, and if I find some I use this report (and the ones that follow) to narrow the search.
Here are the major parts of the report. The first band shows the Top Blocking Transactions, and the following bands show the blocking SQL Server Statement, whether the block is direct or indirect, and then the blocked SQL Statement. Since some of the columns repeat in these bands, I’ll just explain them all in a single table :
In this continuing series on the Standard Reports in SQL Server Management Studio , we’re now up to the