Identify Blocked SQL Processes Quickly: Figure 2 Select Records from the Table.
The SQL code used in the blocking example starts selecting records from the tblCountry table, while a pending transaction exists against the same table. The status on the bottom left-hand side of the window says "Executing query … " The query cannot obtain the records because of the previously created transaction.