Forum Discussion
Compatibility change from 110 to 160 doubles the CPU
You might be getting higher CPU usage put maybe for some time, basically when all calls get recompiled.
I'll suggest you to use Query Store and maybe try to identify sessions with high cpu.
You can also enable Query store that will help
Additionally you can try sp_whoisactive to detect sessions taking most of the resources
One more thing, check optimize for ad hoc workloads configuration that might help
Regards
Javier
No, even after hours, days, the CPU stays at a double utilization pre-change to compatibility level to 160.
I have been trying to use the Query Store, even though this is new to me, but I haven't been able to target or figure out which queries are slowing their execution time after the compatibility change.
I use sp_whoisactive, so far I have not been able to figure out the culprits.
I just checked "optimize for ad hoc workloads" and it is set to 0. Ok, this is something I'll look into, read about it again and probably turn it on, and later change the compatibility level back to 160 again.
Thank you.