Bulk update locks are applied by the database engine when multiple threads perform bulk copying of data into the same table. Applying these locks allows the threads to bulk load data at the same time into the same table, while preventing access to the table from other processes, which do not carry out data bulk loading.
Intent locks are locks used by the database in order to protect a resource that is found lower in the lock hierarchy from a shared (S) lock or exclusive (X) lock. Because these locks are acquired before a lock at the lower level, they signal intent to place locks at a lower level.
© 2023 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center