Page History
...
By default, blocked sessions wait for a lock wait forever, which is not optimum behavior. You can change this default behavior by making a connection, and then adding SET LOCKTIMEOUT 60000
to the top of the first T-SQL batch.
Reduce the number of blocked sessions
If you experience more than one blocked session on an average day, your site may experience one of the following issues:
...