O'Reilly logo

Pro SQL Server Internals, Second Edition 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

© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_22

22. Application Locks

Dmitri Korotkevitch

(1)Tampa, Florida, USA

This chapter discusses another SQL Server locking feature called application locks, which allow you to place locks on an application’s resources as identified by name. One of the most common scenarios where application locks are beneficial is serializing access to T-SQL code in the client application, similar to critical sections and mutexes.

Application Locks Overview

Application locks allow an application to place a lock on an application resource, which is not related to database objects and is identified by name only. The lock would follow the regular rules in terms of lock compatibility, ...

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