I am trying to use Query Performance Insights, in the Azure management portal, to view resource-consuming queries, etc. I am interested in doing so with 2 databases. I am having difficulty in doing so for one of the two databases, & am wondering if it's some sort of permissions issue.
With database A, using the portal, I can click on the resource (the database), then scroll down the left-side menu & click Query Performance Insight. This displays a screen with the top 5 resource-consuming queries. I can then click on one of the colored QueryID boxes & this displays another page, one with the query text on top & query performance stats graphically displayed in the bottom half.
With database B, I can do the same, EXCEPT for the final page. If I click on the colored QueryID box, it does display the final page, BUT it doesn't display the query text nor does it display the graphical query statistics. It simply displays a generic query on the top, & a message stating that the query timed out. It does this for any query, & refresh does not resolve it.
Both databases are basically quite similar. One does have more concurrent users.
Does this sound like a resource issue, a permissions issue, ?
Thanks for any recommendations.