Thanks. Can you comment on Query store, Forced a good plan with query store and left query store on to capture all. So far the server is operating well. Would you think this would help for the cause of high CPU. I have query store max size of 100MB. What happens if the query store reach to max size. Would there be any impact to database other than the collection of data?
If you have auto-cleanup enabled, query store will remove data. If not, it'll fill up and stop collecting. It won't hurt the server more than it already is. Query Store does a little bit of overhead, but for most people in most situations, nothing radical. You can turn on Query Store, but turn off data collection. That allows you to still do plan forcing if you want, but without the overhead of the data collection.