Address Lock Contention

Number of times a task was switched out because of address locks. Adaptive Server acquires address locks on the index pages of allpages-locked tables. These locks block access to data pages. For example, an exclusive address lock on an index page blocks another system process ID (spid) from reading that page and following that index to the data. However, tasks can still use other access methods to the data.) Also, when a leaf-level index page is exclusively locked, no modifications can be done to any data pointed to by the index rows on the locked page, since the index rows may need to be modified as well.