Page History
...
By default, a blocked session waits forever for a lock. You can change this behavior by adding SET LOCKTIMEOUT 60000 to the top of the first T-SQL batch after you make a connection.
...
| Scroll pdf ignore |
|---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |