“Lock Hashtable Lookups” reports the number of times the lock hash table was searched for a lock on a page, row, or table.
You can configure the size of the lock hash table with the configuration parameter lock hashtable size. If the average number of locks per hash chain is more than 4, consider increasing the size of the hash table. See “Configuring the lock hashtable (Lock Manager)” on page 47 in Performance and Tuning: Locking for more information.
