What Are the Locks in Sql Server

Exclusive (X)Shared (S)Intent exclusive (IX)Intent shared (IS)Shared with intent exclusive (SIX)

What are the types of locks in SQL Server?

• Exclusive (X)
• Shared (S)
• Intent exclusive (IX)
• Intent shared (IS)
• Shared with intent exclusive (SIX)

What are the locks in database?

Locking protocols are used in database management systems as a means of concurrency control. Multiple transactions may request a lock on a data item simultaneously. Hence, we require a mechanism to manage the locking requests made by transactions. Such a mechanism is called as Lock Manager.