Google News
logo
SQL Server - Quiz(MCQ)
__________ wait type applies to SQL Server 2014 only.
A)
HADR_WORK_POOL
B)
HADR_WORK_QUEUE
C)
HADR_XRF_STACK_ACCESS
D)
LCK_M_U_ABORT_BLOCKERS

Correct Answer :   LCK_M_U_ABORT_BLOCKERS


Explanation : LCK_M_U_ABORT_BLOCKERS occurs when a task is waiting to acquire an Update lock with Abort Blockers.

Advertisement