OQS comes with a standard reporting solution that integrates straight into SQL Server Management Studio and allows you to query, visualize, and analyze the data inside OQS.

Here is a screenshot of the integrated OQS Dashboard:

Let's go through the dashboard starting at the top left:

• The donut chart display the top 10 queries that have been executed in the last hour based on the average elapsed time of the query.
• The bar chart next to it shows the top 10 queries in the last hour based on the amount of executions.
• The line chart returns the amount of unique query executions in the last hour. Compared to the bar chart on the left, this graph does not return a total amount of executions but rather the amount of unique, distinct, queries that have been executed.
• The last chart on the top row is the Execution Plan Diversity tree map. This chart shows the amount of different types of execution plans in the last hour. If you mouse-over one of the blocks a popup will tell you what type of plan the count represents (for instance: Ad-hoc or Proc).

The graphs underneath the “Resource usage overview” all show performance metrics of all queries aggregated over the collection intervals. The area chart shows the minimum and maximum values while the line displays the average value. All of these graphs are based on the performance metrics collected in the last eight hours. The resource graphs available are: Worker Time Consumption, Logical Reads & Writes and Elapsed Query Time. The graph at the bottom right is the “Queries with multiple plans” bar chart. Like the name suggests this chart shows the query IDs of query statements that generated more than one Execution Plan. Since the detection of multi-plan statements is pretty complex we dedicated a separate section with a bit more detail about the process here.

Finally, the charts at the bottom beneath the “Open Query Store info” section return information about the Open Query Store itself. The pie chart on the left shows the space (in KB) the Open Query Store is taking up inside the database. The bar chart next to it returns the amount of items inside the Open Query Store based on the item count (for instance, it shows the amount of plans, queries, etc). The table on the right returns the log information of the latest iteration of the OQS gather script. This allows you to immediately see what the Open Query Store did the last time it collected data.