This page explains the LCK_M_IX wait type and gives examples of where it occurs in SQL Server.
Added in SQL Server version: 2014 Removed in SQL Server version: N/A Extended Events wait_type value: Themap_keyvalue insys.dm_xe_map_valuesis 940 in 2014 RTM. After 2014 RTM, you must check the DMV to get the latest value as somemap_keyvalues have changed in later builds. ...
Description 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 op...
Description 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 op...