Export (0) Print
Expand All

Database Engine Tuning Advisor (Reports Tab)

The Reports tab appears after Database Engine Tuning Advisor completes analysis of a workload.

Tuning Summary

Displays a summary of the Database Engine Tuning Advisor recommendations.

Date

The date that Database Engine Tuning Advisor created the report.

Time

The time that Database Engine Tuning Advisor created the report.

Server

The server that was the target of the Database Engine Tuning Advisor workload.

Databases to tune

The database affected by Database Engine Tuning Advisor recommendations.

Workload file

Appears when the workload is a file.

Workload table

Appears when the workload is a SQL Server table.

Workload

Appears when the workload has been imported from the Query Editor in SQL Server Management Studio.

Maximum tuning time

The maximum time configured to be available for the Database Engine Tuning Advisor analysis.

Time taken for tuning

The time actually used by Database Engine Tuning Advisor to analyze the workload.

Expected percentage improvement

The percentage improvement expected with the target workload if all Database Engine Tuning Advisor recommendations are implemented.

Maximum space for recommendation (MB)

The maximum space considered for the recommendations. This value is configured before the analysis is made, using the Advanced Options button, on the Tuning Options tab.

Space used currently (MB)

The space currently used by indexes in the database analyzed.

Space used by recommendation (MB)

The approximate space expected to be used by indexes if all the Database Engine Tuning Advisor recommendations are implemented.

Number of events in workload

Number of events contained in the workload.

Number of events tuned

Number of events in the workload that were tuned. If an event cannot be tuned, it is listed in the tuning log, which is available on the Progress tab.

Number of statements tuned

Number of statements in the workload that were tuned. If a statement cannot be tuned, it is listed in the tuning log which is available on the Progress tab.

Percent SELECT statements in the tuned set

Percentage of tuned statements that are SELECT statements. Only appears if there are SELECT statements that have been tuned.

Percent UPDATE statements in the tuned set

Percentage of tuned statements that are UPDATE statements. Only appears if there are UPDATE statements that have been tuned.

Number of indexes recommended to be [created | dropped]

Recommended number of indexes to be created or dropped on the tuned database. Only appears if indexes are part of the recommendation.

Number of indexes on views recommended to be [created | dropped]

Recommended number of indexes on views to be created or dropped on the tuned database. Only appears if indexes on views are part of the recommendation.

Number of statistics recommended to be created

Recommended number of statistics to be created on the tuned database. Only appears if statistics are recommended.

Select Report

See the details of the selected report. The columns in the grid vary with each report.

Community Additions

ADD
Show:
© 2014 Microsoft