Azure SQL Database
An Azure relational database service.
6,034 questions
Need help understanding Query performance insights for Azure sql
![](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(92.8, 43%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Ryan Brown
0
Reputation points
- In Azure I go to my database and choose Performance Overview | Query Performance insight and it shows me long running queries.
- I click it to get details and I then click again to see the details of one of the queries.
- It says in the last 24 hours it has run 44 times for a total of over 8 hours. (First screenshot)
- I click it to see what the query was. (Second and third screenshot)
- The sql query it shows is nowhere in our code.
{count} votes
-
Erland Sommarskog 117.5K Reputation points MVP2025-02-25T22:19:28.17+00:00 Since I don't know anything about your database or environment, I don't know exactly what you define as "our code". It could be a query coming in from the left from a Power BI report or similar.
I would set up some form of auditing or extended-events session to get more information of what this may be coming from.
Sign in to comment
Sign in to answer