Ansicht
Dokumentation

dbs/mss/update_with_updlock - MSSQL: Set UPDLOCK hint on all UPDATE SQL statements

dbs/mss/update_with_updlock - MSSQL: Set UPDLOCK hint on all UPDATE SQL statements

General Material Data   General Data in Customer Master  
This documentation is copyright by SAP AG.
SAP E-Book
------------------------------------------------------------------------
| 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 )