O'Reilly logo

Pro SQL Server Internals by Dmitri Korotkevitch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 22

image

Application Locks

There is another interesting SQL Server feature called application locks. This feature allows an application to place the lock to the application resource, which is not related to the database objects and identified by the name only. The lock would follow the regular rules in terms of the lock compatibility, and it can be one of the following types: shared (S), update (U), exclusive (X), intent shared (IS), and intent exclusive (IX).

image Note  Chapter 17 (Lock Types) describes lock capability matrix.

An application needs ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required