Query Store and Monitor not aligned
postledm
Posts: 8 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:
