Parameter
dbs/mss/update_with_updlock
Short text
MSSQL: Set UPDLOCK hint on all UPDATE SQL statem
Parameter Description
When this parameter is turned off, SQL UPDATE statements will no longer contain an added hint: UPDLOCK HOLDLOCK. This hint has been used for years in MS SQL Server to avoid deadlocks mainly in the spool area (TSP tables). The hint does reduce concurrency, so if no deadlocks are observed without this flag, it can be turned off to gain some performance through increased concurrency.
Application Area
Database
Parameter Unit
0/1
Default Value
1
