I saw some new database scoped configurations like MAXDOP and legacy cardinality for secondary options and have few questions or doubts i am not able to understand
How do i setup MAXDOP, say for primary OLTP it needs to be 8 but on readable secondary i want the value to be 4? This is to make sure after AG failover i don't need to manually change those MAXDOP again, should i be setting these values on P and S both?
If db compat is changed to 140 but performance for Primary OLTP its better when Legacy CE option is ON and on readable secondary's due to different DW workload works better when Legacy CE OFF. How i change such settings so that during failover they are unchanged or we do not need to keep a track of things changing and go about manually changing it