Description This wait occurs when a request is waiting to acquire a Schema Modify lock with the low priority options added in SQL Server 2014. This mechanism protects a schema from modification by other requests. This lock typically occurs during long schema changes for example: adding additional non-NULL columns, change column data types, rebuilding indexes […]

Description This wait occurs when a request is waiting to acquire a shared lock with the low priority options added in SQL Server 2014. This typically happens when read requests are blocked by write transactions (implicit of explicit) been kept open for extended periods of time. The low priority operations must not be set to […]

Description Occurs while waiting for non-data-file disk I/O to complete. For example while growing a transaction log disk I/O is required to zero-out the file. Backup and restore operations can also accumulate this wait counter. As this wait accumulates during backups moderate values are expected Resolved by DBAs and Developers Suggested solutions If possible, run […]

Description This wait occurs when a request is waiting to acquire a shared lock. This typically happens when read requests are blocked by write transactions (implicit or explicit) that have been kept open for extended periods of time Resolved by DBAs and Developers Suggested solutions Keep transaction durations short. Ensure transactions isolation levels are appropriate […]

Description This wait occurs when a request is waiting to acquire a Key Range Insert Exclusive lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. An exclusive lock typically occurs when read […]

Description This wait occurs when a request is waiting to acquire a Key Range Exclusive lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. An exclusive lock typically occurs when read and […]

Description This wait occurs when a request is waiting to acquire a Key Range Exclusive lock. This mechanism acquires locks on a subset of rows in an index but only if the transaction isolation SERIALIZABLE is used. An exclusive lock typically occurs when read and modify requests are blocked by another write transaction (implicit of […]

Description This wait occurs when a request is waiting to acquire a Shared-Range Update lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. An update lock typically occurs when read and modify […]

Description This wait occurs when a request is waiting to acquire a Key Range Update lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. An update lock typically occurs when read and […]

Description This wait occurs when a request is waiting to acquire a Key Range Update lock. This mechanism acquires locks on a subset of rows in an index but only if the transaction isolation SERIALIZABLE is used. An update lock typically occurs when read and modify requests are blocked by another write transaction (implicit of […]

Description This wait occurs when a request is waiting to acquire a Key Range Share lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. A share lock typically occurs when read requests […]

Description This wait occurs when a request is waiting to acquire a Key Range Share lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. A share lock typically occurs when read requests […]

Description This wait occurs when a request is waiting to acquire a Key Range Share lock. This mechanism acquires locks on a subset of rows in an index but only if the transaction isolation SERIALIZABLE is used. A share lock typically occurs when read requests are blocked by another transaction (implicit of explicit) that has […]

Description This wait occurs when a request is waiting to acquire a Shared-Range Update lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. An update lock typically occurs when read and modify […]

Description This wait occurs when a request is waiting to acquire a Shared-Range Update lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. An update lock typically occurs when read and modify […]

Description This wait occurs when a request is waiting to acquire a Shared-Range Update lock. This mechanism acquires locks on a subset of rows in an index but only if the transaction isolation SERIALIZABLE is used. An update lock typically occurs when read and modify requests are blocked by another write transaction (implicit of explicit) […]

Description This wait occurs when a request is waiting to acquire a Shared-Range Share lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. A share lock typically occurs when read requests are […]

Description This wait occurs when a request is waiting to acquire a Shared-Range Share lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. A share lock typically occurs when read requests are […]

Description This wait occurs when a request is waiting to acquire a Shared-Range Share lock. This mechanism acquires locks on a subset of rows in an index but only if the transaction isolation SERIALIZABLE is used. A share lock typically occurs when read requests are blocked by another transaction (implicit of explicit) that has been […]

Description This wait occurs when a request is waiting to acquire a Key Range Insert Exclusive lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. An exclusive lock typically occurs when read […]

Description This wait occurs when a request is waiting to acquire a Key Range Insert Exclusive lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. An exclusive lock typically occurs when read […]

Description This wait occurs when a request is waiting to acquire a Key Range Insert Exclusive lock. This mechanism acquires locks on a subset of rows in an index but only if the transaction isolation SERIALIZABLE is used. An exclusive lock typically occurs when read and modify requests are blocked by another write transaction (implicit […]

Description This wait occurs when a request is waiting to acquire a Key Range Insert Update lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. An update lock typically occurs when read […]

Description This wait occurs when a request is waiting to acquire a Key Range Insert Update lock with the low priority options added in SQL Server 2014. This mechanism acquires locks on a subset of rows in an index but only when the transaction isolation SERIALIZABLE is used. An update lock typically occurs when read […]

Description This wait occurs when a request is waiting to acquire a Key Range Insert Update lock. This mechanism acquires locks on a subset of rows in an index but only if the transaction isolation SERIALIZABLE is used. An update lock typically occurs when read and modify requests are blocked by another write transaction (implicit […]