Occurs when a task is waiting to acquire an Update With Intent Exclusive lock. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.
- Google Search for sqlserver - LCK_M_UIX
- Ecosia Search for sqlserver - LCK_M_UIX
- Bing Search for sqlserver - LCK_M_UIX