Resource hash table latch contentions

Statistics - Resource hash table latch contentions

The field labels shown in the following sample layout of Statistics - Resource hash table latch contentions are described in the following section.

RESOURCE HASH TABLE LATCH CONT  QUANTITY  /SECOND  /THREAD  /COMMIT
------------------------------  --------  -------  -------  -------
LOCK                                1.00     0.00     0.00     0.00
UNLOCK                              1.00     0.00     0.00     0.00
CHANGE                              0.00     0.00     0.00     0.00
COMPAT                              0.00     0.00     0.00     0.00
ASYNC LOCK                          0.00     0.00     0.00     0.00
QUERY FAST                          0.00     0.00     0.00     0.00
NOTIFY                              0.00     0.00     0.00     0.00

RESOURCE LATCH CONTENTIONS - LOCK

Resource Hash Table latch contention for LOCK.

Field Name: QTXACRLK

RESOURCE LATCH CONTENTIONS - UNLOCK

Resource Hash Table latch contention for UNLOCK.

Field Name: QTXACRUK

RESOURCE LATCH CONTENTIONS - CHANGE

Resource Hash Table latch contention for CHANGE.

Field Name: QTXACRCH

RESOURCE LATCH CONTENTIONS - COMPAT

Resource Hash Table latch contention for COMPAT.

Field Name: QTXACRCP

RESOURCE LATCH CONTENTIONS - ASYNC LOCK

Resource Hash Table latch contention for ASYNC LOCK.

Field Name: QTXACRAL

RESOURCE LATCH CONTENTIONS - QUERY FAST

Resource Hash Table latch contention for QUERY FAST.

Field Name: QTXACRQF

RESOURCE LATCH CONTENTIONS - NOTIFY

Resource Hash Table latch contention for NOTIFY.

Field Name: QTXACRNT