This page explains the LCK_M_IS wait type and gives examples of where it occurs in SQL Server.
Removed in SQL Server version: N/A Extended Events wait_type value: The map_key value in sys.dm_xe_map_values is 959 in 2014 RTM. After 2014 RTM, you must check the DMV to get the latest value as some map_key values have changed in later builds. Other information: I have not see...
This wait occurs when a request is waiting to acquire an Intent Shared lock with the low priority options added in SQL Server 2014. These locks are required to protect the object or data of other requests. For example when a query is run on a table an Intent Shared lock is placed on t...
This wait occurs when a request is waiting to acquire an Intent Shared lock with the low priority options added in SQL Server 2014. These locks are required to protect the object or data of other requests. For example when a query is run on a table an Intent Shared lock is placed on t...