This wait type exists so that all lock modes have_LOW_PRIORITYand_ABORT_BLOCKERSwait types, but this wait type is not used. The only_LOW_PRIORITYand_ABORT_BLOCKERSwait types that are used, during online index and partition switching operations, are: ...
This page explains the LCK_M_IX wait type and gives examples of where it occurs in SQL Server.
This wait occurs when a request is waiting to acquire an Intent Exclusive lock with the low priority options added in SQL Server 2014. This style of locking typically happens when read and modify requests are blocked by write transactions (implicit of explicit) that have been kept open for ext...
This wait occurs when a request is waiting to acquire an Intent Exclusive lock with the low priority options added in SQL Server 2014. This style of locking typically happens when read and modify requests are blocked by write transactions (implicit of explicit) that have been kept open for ext...