• Article

Database Engine Tuning Advisor (Reports Tab)

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

Options

  • 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.