Azure SQL Managed Instance - A performance optimization change to default settings is coming soon

Azure Updates

Discussionpowered by zap.ms

Published

Mar 31, 2021

Status

In development

Timeline

  • March 2021
    Private Preview

Product

Azure SQL Managed Instance

Tag

Features

Category

Databases

Description

Coming soon in May 2021, the default maximum degree of parallelism (MAXDOP) option for new SQL managed instances will change from 0 to 8. This will help improve workload performance and reduce unnecessary resource utilization.

For details and answers to frequently asked questions, read the Changing default MAXDOP in Azure SQL Managed Instance blog post.