Optimistic index locking can resolve increased contention on some important resources, such as the spinlocks that guard address locks on the root page of an index.
Applications where this amount of contention might occur are typically those in which:
Access to a specified index constitutes a significant portion of the transaction profile, and many users are concurrently executing the same workload.
Different transactions, such as ad hoc and standardized queries, use the same index concurrently.
