Paramètre SAP dbs/mss/update_with_updlock - MSSQL: Set UPDLOCK hint on all UPDATE SQL statements

Parameter dbs/mss/update_with_updlock Short text MSSQL: Set UPDLOCK hint on all UPDATE SQL statemWhen this parameter is turned off, SQL UPDATE statements will nolonger contain an added hint: UPDLOCK HOLDLOCK. This hint has beenused for years in MS SQL Server to avoid deadlocks mainly in thespool area (TSP tables). The hint does reduce concurrency, so ifno deadlocks are observed without this flag, it can be turned off togain some performance through increased concurrency. Work area Database Parameter unit 0/1 Default value 1