You can use this feature when any or all of the following conditions are true:
There is significant contention on the lock address hash bucket spinlock.
None of the indexes on this table cause modifications to the root page.
The number of index levels is high enough to cause no splitting or shrinking of the root page.
There are large numbers of concurrent accesses to read-only tables on heavily trafficked index pages.
A database is read-only.
