LOCKING HOW IT HAPPENS IN REAL TIME.[SP_WHO2]

Split the vertical tab.First the query window 52 followed by 53.

Execute in query window 52.

begin transaction

select

update

execute in query window 53.

select

Now execute which are ticked.....

53 is blocked by 52. And the wait time increases ...never stops unless and untill you commit the transaction in 52.

Once you commit the transaction in 52. Lock gets released.  

SP_WHO2 

The above command tells you the details about the blocking