Dimitri_Furman

Changing default MAXDOP in Azure SQL Database

Executive Summary To improve customer workload performance and reduce unnecessary resource utilization, the default MAXDOP setting for new databases in Azure SQL Database is changing from the previous default of 0 (unlimited) to 8. Why MAXDOP matters The “max degree of parallelism” (a.k.a. MAXDOP) SQL Server configuration option controls the ability of the database engine …

Changing default MAXDOP in Azure SQL Database Continue Reading

Improving concurrency of asynchronous statistics update

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 priority queue. This improves concurrency for workloads with frequent query plan (re)compilations. New behavior is enabled with the ASYNC_STATS_UPDATE_WAIT_AT_LOW_PRIORITY database-scoped configuration. This feature is currently in …

Improving concurrency of asynchronous statistics update Continue Reading