Versions Compared

Old Version 3

changes.mady.by.user Unknown User (6092b4ded35380006886a5ee)

Saved on

compared with

New Version 4

changes.mady.by.user Unknown User (6092b4ded35380006886a5ee)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:

...