Choosing a Database Engine Tuning Advisor Report

After Database Engine Tuning Advisor finishes analyzing a workload, it generates a set of analysis reports. You can use the Database Engine Tuning Advisor graphical user interface tool (GUI) to view these reports or you can view the XML output with your favorite XML tools. The following table lists and describes each report that Database Engine Tuning Advisor generates.

Types of Database Engine Tuning Advisor Analysis Reports

Analysis report name Description

Column Access Report

Provides the same type of information as the Table Access Report except that this report lists each column and table that is referenced in the workload.

Database Access Report

Lists each database that is referenced in the workload and the number of references to that database. This report also lists what percentage of workload statements reference each database. For example, if only one database is referenced, the usage for that database will be 100 percent.

Event Frequency Report

Lists all events contained in the workload and orders them by frequency of occurrence.

Index Detail Report

(current configuration)

Lists detailed information about each index in the current configuration that is referenced by the workload. It provides information such as whether this index is clustered, unique, its size in megabytes (MB), and so on.

Index Detail Report

(recommended configuration)

Provides the same information as the Current Index Detail Report except that the information contained in this report pertains to the recommended configuration.

Index Usage Report

(current configuration)

Lists the indexes in the current configuration that are referenced by statements in the workload and the percentage of statements in the workload that reference each index. For example, if a workload contains 10 statements and all 10 statements reference a particular index, that index will have a 100 percent usage.

Index Usage Report

(recommended configuration)

Provides the same information as the Current Index Usage Report except that the information contained in this report pertains to the recommended configuration.

Statement Cost Report

Each statement that executes against databases incurs a performance cost. This report lists the percentage improvement in performance for each statement contained in the workload if the recommendation is implemented.

Statement Cost Range Report

Lists how many of the workload statements fall within 10 percentage-point cost ranges for both the current configuration and for the recommended configuration. For example, this report may show that the 30 workload statements fall within the 61 percent to 70 percent cost range for the current configuration, but if the recommendation were implemented, 20 of the statements would fall within the 11 percent to 20 percent range and 10 would fall within the 0 percent to 10 percent range.

Statement Detail Report

Lists all statements in the workload, their current cost, and their cost if the recommendation is implemented.

Statement-to-Index Relationship Report

(current configuration)

Lists each statement in the workload and the indexes referenced by each statement for the current configuration.

Statement-to-Index Relationship Report

(recommended configuration)

Lists each statement in the workload and the indexes that would be referenced by each statement if the recommended configuration were implemented.

Table Access Report

Provides the same type of information as the Database Access Report except that this report lists each table that is referenced in the workload.

View-to-Table Relationship Report

Lists information about the tables that are referenced by materialized views.

Workload Analysis Report

Lists information about the workload, such as total number of statements, number of statements whose cost has been decreased in the tuning recommendation, number of statements whose cost remains unchanged, and so on.

See Also

Tasks

How to: View Tuning Output

Help and Information

Getting SQL Server 2005 Assistance