question

galletto avatar image
0 Votes"
galletto asked WilldeHaan-7129 commented

Azure Query Performance Insight hangs on loading

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


azure-sql-database
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@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?

0 Votes 0 ·
galletto avatar image galletto KalyanChanumolu-MSFT ·

No, it happens often, not always. Today is a good day...

0 Votes 0 ·
WilldeHaan-7129 avatar image WilldeHaan-7129 KalyanChanumolu-MSFT ·

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

0 Votes 0 ·
WilldeHaan-7129 avatar image WilldeHaan-7129 KalyanChanumolu-MSFT ·

Here's a screenshot:




[1]: /answers/storage/attachments/133495-schermafbeelding-2021-09-20-090259.png

0 Votes 0 ·

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered galletto commented

Could you try using Azure Monitor as recommended here?



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

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

0 Votes 0 ·