Azure SQL Database
An Azure relational database service.
5,444 questions
Could you try using Azure Monitor as recommended here?
Azure Query Performance Insight hangs on loading
galletto
186
Reputation points
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
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KalyanChanumolu-MSFT 8,321 Reputation points2021-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 186 Reputation points
2021-07-06T07:54:56.893+00:00 No, it happens often, not always. Today is a good day...
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 11%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWD%3C/text%3E%3C/svg%3E)
Will de Haan 1 Reputation point2021-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:
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 25%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Salvador Sosa 1 Reputation point2022-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
Sign in to comment
1 answer
Sort by: Most helpful
-
Alberto Morillo 33,426 Reputation points MVP2021-07-05T19:17:25.823+00:00 -
galletto 186 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?
Sign in to comment -