8 Types of SQL Server locks

The 1th kind,

Shared locks, generated by read lookups.

The 2nd kind,

Intent locks, with intent locks, indicate the intention to acquire a resource.

The 3rd kind,

Update the lock and get it before modifying the data.

The 4th kind,

Exclusive lock, which is used to monopolize a resource.

The 5th Kind,

Schema locks, which are generated when a DDL statement is run.

The 6th kind,

The schema is stable, generated at query compile time, so that the DDL cannot be performed on the table.

The 7th kind,

High-volume update locks, which generate such locks during bulk copy, such as locking the IDs by 1~100000 these lines at the same time, many rows with a lock.

The 8th kind,

A key range lock, which protects a series of rows according to the key range.

8 Types of SQL Server locks