- Individual SQL query statements can also be retrieved from Query Store and Extended Events
A Table Visual filtered for the top 10 SQL Query values based on the Duration measure
- The top N visual level filter is applied to a table visual based on the Avg Duration measure
This recipe focused primarily on dashboard content that addresses top, high-level monitoring questions. However, a layer of detailed reports, including visuals such as this top X queries by duration (or I/O, CPU, and so on), would likely be valuable complements in the summary-level reports and dashboards. Note that table visuals support ...