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:
...
| Tip | ||
|---|---|---|
| ||
Create an alert response bundle with the Blocked Sessions (Count) alert and related alerts. For additional information, see Create alert response bundles. |
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...
...