Database Reference
In-Depth Information
Figure 23-11.
Low-priority locks
■
It is essential to remember that, as soon as a low-priority lock is acquired, it will then behave the same as
a regular lock, preventing other sessions from acquiring incompatible locks on the resource.
Important
Figure
23-12
shows the output of the query from Listing 18-1 in Chapter 18. It demonstrates how low-priority
locks are shown in the
sys.dm_tran_locks
data management view output. It is worth noting that the view does not
provide the wait time of those locks.
Figure 23-12.
Low-priority locks in the
sys.dm_tran_locks
data management view
You can specify lock priority with a
WAIT_AT_LOW_PRIORITY
clause in the
ALTER INDEX
and
ALTER TABLE
statements, as shown in Listing 23-1.