High CPU usage when using database Compatibility Level of SQL 2019

Dashboard Server
1

Hello,

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?

Kind Regards,

JM

2

Looks like a good candidate for a call with Microsoft support. SQL Server CU9 is supported and no mention of the compatibility level. I would recommend though that the Operational and DW have the same configuration…

3

I think Pascal is right, you may have to call with msft support. I have seen another occurrence where the compatibility mode made a difference, just cant remember what it was about exactly. Ended up putting it back to the level it was at before.
Some things are supported as you can see, however not every possible combination of settings has been tested. SQL 2019 is newer than SCOM 2019, so only after the fact testing was done, likely in some of the same ways you did, by migrating and leaving settings the same. There were just issues with SQL19 before CU9 in combination with SCOM.

1 Like