'MAXDOP gets reset back to default in Cloud SQL Server
Since Cloud SQL Server is a managed database I can't set maximum degree of parallelism on an instance level, but am able override it by altering MAXDOP on a database level in DATABASE SCOPED CONFIGURATION. But for some reason, this MAXDOP gets very randomly reset back to default 0. As it affects the overall performance, I would like to understand how can this be fixed. Thank you in advance for all the suggestions
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|