The value for WaitTime for this event can be high if there is contention for a particular table or page (such as a high number of heap inserts). Query monLocks and monOpenObjectActivity to identify objects that are experiencing heavy lock contention.
In some situations, you can reduce the amount of lock contention by changing the table’s locking scheme from allpages locking to data-only locking. Application or database design typically causes lock contention; evaluate your application design to determine the best method to reduce lock contention, while still considering other application requirements.
