January 9, 2018 at 12:03 pm
Greetings,
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.
Randy
January 9, 2018 at 2:26 pm
You're just querying the Query Store within the database, so it ought to be relatively pain free. It sounds more like contention, but I wouldn't expect to see that much contention generally. Is that database maxed out on it's DTUs?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply