Azure Query Performance Insight hangs on loading

Question

Azure Query Performance Insight hangs on loading

galletto 166

More often than not, when I try to open Query Performance Insights on an Azure SQL database , it never gets past "loading".
On the bottom, it states: "At this time, there is no performance data available. Please check again later."
When I open SSMS, I can check the Query store OK.
What's going wrong?

Thanks,
Will de Haan

KalyanChanumolu-MSFT 8,251 Reputation points Microsoft Employee

2021-07-06T02:23:36.357+00:00

@galletto Thank you for reaching out.
Do you see this behavior every time you access Query Performance Insights from the Azure Portal?
Could you please post a screenshot?
galletto 166 Reputation points

2021-07-06T07:54:56.893+00:00

No, it happens often, not always. Today is a good day...
Will de Haan 1 Reputation point

2021-09-20T06:59:15.703+00:00

Hi ,

I keep having this issue. Lastly, it seems that it never gets any results. What's going on? Is there a service issue with Query Performance Insight?
Thanks for any help,
Will de Haan
Will de Haan 1 Reputation point

2021-09-20T07:05:27.227+00:00

Here's a screenshot:
Salvador Sosa 1 Reputation point

2022-09-27T16:52:19.937+00:00

i have the same problem
Salvador Sosa 1 Reputation point

2022-09-27T16:52:31.083+00:00

i have the same problem

KalyanChanumolu-MSFT 8,251 Reputation points Microsoft Employee

2021-07-06T02:23:36.357+00:00

@galletto Thank you for reaching out.
Do you see this behavior every time you access Query Performance Insights from the Azure Portal?
Could you please post a screenshot?
galletto 166 Reputation points

2021-07-06T07:54:56.893+00:00

No, it happens often, not always. Today is a good day...
Will de Haan 1 Reputation point

2021-09-20T06:59:15.703+00:00

Hi ,

I keep having this issue. Lastly, it seems that it never gets any results. What's going on? Is there a service issue with Query Performance Insight?
Thanks for any help,
Will de Haan
Will de Haan 1 Reputation point

2021-09-20T07:05:27.227+00:00

Here's a screenshot:
Salvador Sosa 1 Reputation point

2022-09-27T16:52:19.937+00:00

i have the same problem
Salvador Sosa 1 Reputation point

2022-09-27T16:52:31.083+00:00

i have the same problem

Answer 1

Alberto Morillo 26,131 MVP

Could you try using Azure Monitor as recommended here?

galletto 166 Reputation points

2021-07-06T07:52:41.117+00:00

Hi,

I I don't see how Azure Monitor could help investigating query performance. Am I missing something?

Azure Query Performance Insight hangs on loading

1 answer

Activity