SQL Server 2014 (and Azure SQL Database V12) added some cool new functionality for online index operations to allow you to prevent long-term blocking because of the two blocking locks that online index operations require. At the start of any online index operation, it acquires a S (share) table lock. This lock will be blocked until [&]

The post Low priority locking wait types appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/yZuELuaLFjc/