Blog Post

Azure SQL Blog
8 MIN READ

Improving concurrency of asynchronous statistics update

Dimitri_Furman's avatar
Dimitri_Furman
Icon for Microsoft rankMicrosoft
Jun 16, 2020
Executive summary   In Azure SQL Database and Azure SQL Managed Instance, the background process that updates statistics asynchronously can now wait for the schema modification lock on a low prio...
Updated Jun 17, 2021
Version 4.0
azure sql
Dimitri_Furman's avatar
Dimitri_Furman
Icon for Microsoft rankMicrosoft
Mar 21, 2024

Kurt_Yang - yes, as any DDL operation, statistics update requires a Sch-M lock, which could block other requests. But typically, this is a very short-lived lock. The benefits of up-to-date statistics far outweigh the risk of blocking.