Azure SQL Database—A performance optimization change to default settings is coming soon

Azure Updates

Discussionpowered by zap.ms

Published

Jul 25, 2020

Timeline

  • July 2020
    General Availability

Tag

Features

Description

The default maximum degree of parallelism (MAXDOP) option for new single databases and elastic pool databases in Azure SQL Database will soon change from 0 to 8. This will help improve customer workload performance and reduce unnecessary resource utilization.

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