I'm continuing my series on the Standard Reports in SQL Server Management Studio, and today I'm covering a report that shows more about locking activity, by transaction.
Before I begin describing the columns and values in this report, it might make some sense to talk a little about the locking and blocking in the database engine. I've covered this in some of the other reports, but I wanted to point out some links that might be useful about locks:
OK - down to the task at hand: This report shows locks by transactions, and the first band groups everything by Transaction ID:
The next band groups the information by Database Name:
Another band below that shows the Resource Name. This is the object being locked. Below that is a row for each type of lock taken:
The final band shows a part of the Currently Executing SQL Statement. This might be blank if the locks are system-generated.
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today I'm
PingBack from http://www.debtconsolidation.get1t.com/?p=342