SQLServer2022

I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up blocking an asynchronous statistics update. This interaction led to a large blocking chain where queries were waiting on the async stats update and started to timeout.

Consultants hate me for this one weird trick. Because I’ll be uncovering all the mess Scalar functions can cause in a series of articles.

The SQL Server 2022 CTP has dropped, and I took a look at the new Extended Events that are available.