6.1.2.1 Reviewing the SQL Performance Analyzer Report: General Information

The General Information section contains basic information and metadata about the workload comparison performed by SQL Performance Analyzer.

To review general information:

  1. On the SQL Performance Analyzer Task Report page, review the summary at the top of the page.
    Description of GUID-22B69F1E-5CFC-4113-BB4E-4C228AAB387F-default.gif follows
    Description of the illustration GUID-22B69F1E-5CFC-4113-BB4E-4C228AAB387F-default.gif

    This summary includes the following information:

    • The name and owner of the SQL tuning set

    • The total number of SQL statements in the tuning set and the number of SQL statements that had errors, are unsupported, or timed out

    • The names of the SQL trials and the comparison metric used

  2. Optionally, click the link next to SQL Tuning Set Name.

    The SQL Tuning Set page appears.

    This page contains information—such as SQL ID and SQL text—about every SQL statement in the SQL tuning set.

  3. Click the link next to SQL Statements With Errors if errors were found.

    The Errors table reports all errors that occurred while executing a given SQL workload. An error may be reported at the SQL tuning set level if it is common to all SQL executions in the SQL tuning set, or at the execution level if it is specific to a SQL statement or execution plan.

  4. Review the global statistics, as described in "Reviewing the SQL Performance Analyzer Report: Global Statistics".