STEP ONE: CLICK ON ANALYSIS REPORTS
Provide a SQL Server name which has the analysis database and click on “Connect”
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
STEP TWO: SELECT EXISTING ANALYSIS REPORTS
Double click on a report name to open it.
You will be able to get insights into how well your workload is represented from the chart below:
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.
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.
Clicking on a specific query opens that query’s comparison summary.
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).