Yesterday we had a CPU performance problem on one of our SQL servers. We use a tool called DPA that clearly showed one query using a ton of CPU (more than any other query by a long shot). However, when I opened Query Store and looked at "Top Resource Consuming Queries by CPU", the query did not show up at all in the same time period. According to DPA, the query started using a new plan which caused the CPU spike. I wanted to go into Query Store and force the old plan but was not able to do so.
I did find this article that talks about this sort of thing happening but I'm not sure what to do with it...
Anyone experience this before and know how to solve it?