Ansicht
Dokumentation
dbs/mss/update_with_updlock - MSSQL: Set UPDLOCK hint on all UPDATE SQL statements
General Material Data General Data in Customer MasterThis documentation is copyright by SAP AG.
------------------------------------------------------------------------
| Parameter: dbs/mss/update_with_updlock |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short description: 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 |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Unit: 0/1 |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Default value: 1 |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Person(s) allowed to make changes: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for the operating systems: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for database systems: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Are other parameters affected or dependent: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid entries, formats, areas: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short Description : MSSQL: Set UPDLOCK hint on all UPDATE SQL statements
------------------------------------------------------------------------
------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter Type : S
------------------------------------------------------------------------
------------------------------------------------------------------------
| Changes allowed : W
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid for Operating System : *
------------------------------------------------------------------------
------------------------------------------------------------------------
| Dynamic switchable : X
------------------------------------------------------------------------
------------------------------------------------------------------------
| Same on all Servers :
------------------------------------------------------------------------
Addresses (Business Address Services) General Data in Customer Master
This documentation is copyright by SAP AG.
Length: 4629 Date: 20240328 Time: 161021 sap01-206 ( 5 ms )