Query Store and Monitor not aligned
postledm
Posts: 10 New member
Overnight Azure database hit 90%+ cpu regularly for several hours.
Monitor reports and alerts on the excessive cpu
But I can't find a query that would be culprit
Looked in Query Store and there are two queries during the period which stand out head and shoulders over everything else.. One query had average cpu 90,000 ms, total 26million ms
But I can't find those queries in Monitor.
What would be the cause? Developers not impressed that Monitor can't tell them the query causing the issue but had to go back to query Store to find the answer
Monitor reports and alerts on the excessive cpu
But I can't find a query that would be culprit
Looked in Query Store and there are two queries during the period which stand out head and shoulders over everything else.. One query had average cpu 90,000 ms, total 26million ms
But I can't find those queries in Monitor.
What would be the cause? Developers not impressed that Monitor can't tell them the query causing the issue but had to go back to query Store to find the answer
Tagged:
Answers
My apologies for the delayed response on this post and for the issues you've seen.
It seems another customer has reported very similar behaviour. Our development team merged a fix for query inconsistencies against the Query Store on Monday, this will be available in 13.0.35 which I'm hoping will be released in the next couple days. As soon as this release is made available, I'll endeavour to let you know here so that you can try this update and advise if you believe the issue persists.
Tom Claringbold | Redgate Software
Have you visited our Help Center?
Any issues updating or should you believe the issue persists post update please let us know and we can look to create an internal ticket to gather some additional information including logs for this.
Tom Claringbold | Redgate Software
Have you visited our Help Center?