I’m a big fan of the Query Store feature in SQL Server.
From the documentation:
The SQL Server Query Store feature provides you with insight on query plan choice and performance. It simplifies performance troubleshooting by helping you quickly find performance differences caused by query plan changes. Query Store automatically captures a history of queries, plans, and runtime statistics, and retains these for your review. It separates data by time windows so you can see database usage patterns and understand when query plan changes happened on the server.
The only problem is that all this extra monitoring and logging comes with some overhead. If your CPU’s are already going through the roof, enabling the Query store will certainly not help.
Instead of turning it back off, I have a better solution for you:
By default when you turn on Query Store, Capture Mode is set to All. That means that everything is collected(important data or not).
If you change the Capture Mode setting to Auto, you can filter out some of that unimportant data and put less stress on your CPUs (and disk).
From the documentation
Auto – ignore infrequent and queries with insignificant compile and execution duration.
Hope that helps!