When we try to switch the Compatibility Level of the Operations Database to SQL 2019 we are noticing extreme CPU usage on the SQL server.
We are running SCOM for a long time now (started with SCOM 2012) and in the last years we have moved our database multiple times.
Our current setup is SCOM 2019 UR2 on Windows Server 2019 and SQL Server 2019 CU9 on Windows Server 2019.
Has someone experienced this kind of behavior when upgrading the Compatibility Level of the Operation Database?
Any ideas or suggestions to troubleshoot/resolve this?