I’m continuing a series on the Standard Reports you can find in SQL Server Management Studio (SSMS).
We're now up to the "Activity" reports, which show more information than you'll find in SQL Server Management Studio in the "Activity Monitor" node. That view is more immediate; these reports show more detail. This particular report shows a lot of information about transaction blocking. If you're not familiar with transactions, look here for more information. If you're not familiar with locking in SQL Server, look here for more information.
This report will only show something if you have blocking transactions. You'll have multiple descendig grids within a "parent" one if you have any blocks. Here are the columns you'll see in each:
The format of this gried layout is that it shows the blocking session at the top, with all of the statements it blocks stepped down below it. The columns are the same for each.
To find this report, open SSMS, right-click a Server, and then select “Reports” and then “Standard Reports”.This report takes a few moments to render.
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today I'm covering
I've completed documenting all of the Standard Reports in SQL Server Management Studio. You can get to