Viewing Application Performance from the SQL Query Perspective
In the SQL Queries view, you will see a list of all queries sorted by the % of time. Click on any listed SQL statement to go to the detailed Performance view of that query.
Detailed Performance View of the SQL Query
In the performance view of the SQL query a chart displays the number of times a query is executed, represented by dark blue vertical bars, and the average time it took, which corresponds with the light blue shading. Other information for an individual query view includes the total number of calls, average time, and the number of requests per minute.
The table below the graph includes a breakdown of each web app and web request that called the query. Clicking on the app will give you an option to filter by that app or take you to the app's App Dashboard. Clicking on a requested action link that will take you to the Detailed Performance view for that particular requested action.
The table also shows the other details about the request as it is related to the query, such as SQL executions by request, average time of an execution, etc.