This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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)
![](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(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Hi @Ryan Brown
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution
please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
I found someone else asking the same question and they found that it was the exporting to BAC that caused it. I am not doing that. https://techcommunity.microsoft.com/blog/azuredbsupport/unexpected-select-queries-seen-in-the-performance-overview-of-the-azure-portal/368807
How can I tell what is causing it? It's nothing that we are doing, that I can tell.
Hi @Ryan Brown
Thanks for reaching out.
Please check query cache plan, It might generate queries from Application side.
please check the auditing logs to see if you can trace the origin of the query. to do this, you need to enable auditing.
Please refer to the document below for the process of enabling auditing:
https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-setup?view=azuresql
Use Auditing to analyze audit logs and reports
Please refer to this Documentation that might help you:
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.
![](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(300.8, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Hi Ryan Brown,
In addition to @Erland Sommarskog response, you can also consider...
Understanding Query Performance Insight & Tracking Query Execution
Query Performance Insight provides intelligent query analysis for single and pooled Azure SQL databases. It helps identify top resource-consuming and long-running queries in your workload. This allows you to optimize queries to improve overall performance and make efficient use of the resources you are paying for.
How to Identify Who Executed a Query
To track who ran a specific query, you need to enable SQL Auditing.
Azure SQL Auditing
Auditing for Azure SQL Database tracks database events and writes them to:
Next Steps
To find out who executed a specific query:
Please feel free to click the 'Upvote' (Thumbs-up) button and 'Accept as Answer'. This helps the community by allowing others with similar queries to easily find the solution.