Azure – Azure SQL Database—A performance optimization change to default settings is coming soon
The default maximum degree of parallelism (MAXDOP) option in Azure SQL Database is changing from 0 to 8, improving workload performance and optimizing resource utilization.
Read More for the details.