Thursday, February 10, 2022

[google-cloud-sql-discuss] MAXDOP gets reset back to default

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

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/03466e12-1428-4a14-a18a-882f89a2199dn%40googlegroups.com.

No comments:

Post a Comment