Azure SQL Managed Instance - A performance optimization change to default settings is coming soon
Data da publicação: 31 março, 2021
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.