Database Experimentation Assistant – View Existing Analysis Reports


STEP ONE: CLICK ON ANALYSIS REPORTS

Provide a SQL Server name which has the analysis database and click on "Connect"
ExistingReportConnect

Note: if you are missing any dependencies, this screen will prompt you with links to install them. Please install the requirements and click Try Again

PreReqScreen

STEP TWO: SELECT EXISTING ANALYSIS REPORTS

Double click on a report name to open it.

ViewexistingReport

You will be able to get insights into how well your workload is represented from the chart below:

WorkloadRepCharts

 

STEP THREE: UNDERSTANDING THE REPORT

This section walks you through viewing and understanding the report.

  • Click on different slices of the left pie chart to scope the view to show only queries that fall under the following categories.

ReportPieSlices

Degraded queries – queries whose performance was better in A’ than in B.
Errors - queries which error in instance B but do not error in instance A’.
Improved queries – queries which performed better in instance B than in instance A’.
Indeterminate queries – queries whose performance change was uncertain.
Same - queries which performance remained the same across instances A’ and B.

  • Individual Query Drilldown - You can drill down on specific queries by clicking on the query template links to see more detailed information.

QueryDrilldown

Clicking on a specific query opens that query’s comparison summary.

ComparisonSummary

You can also see the A and B instance this specific query ran on as well as a template of what the query may look like. In addition to this, there is a table which displays query information specific to instances A and B. The comparison summary report also has an expandable section for "Error Information" and "Query Plan Information" which shows the errors and plan information for both instances (A' and B).

  • Error Queries - Clicking on the error (red) pie shows Existing errors (that were in A’), New errors (that were shown in B), and Resolved errors (errors that were in A‘ but not in B).

ErrorCharts

 

Comments (1)

  1. None of the queries have data for MeanCpu, MeanReads, MeanWrites for Instance A. For instance A only execution counts and MeanDuration appears. However, for Instance B all the Summary Statistics appear. Could this skew the report information?

Skip to main content