• Article

Database Engine Tuning Advisor (Recommendations Tab)

The Recommendations tab appears after Database Engine Tuning Advisor completes analysis of a workload. This grid contains the recommendations for each object considered. Partition recommendations, if any, are presented in the upper grid, and the index recommendations are presented in the lower grid. The grids do not appear if there are no recommendations.

The Definition column contains the definition of the recommended partition or index as a hyperlink. This column is usually too narrow to see the entire definition. Click the hyperlink to display a dialog box containing the full definition and the Copy to Clipboard button.

Partition Recommendations

  • Database Name
    The database containing the objects recommended to be modified.

  • Recommendation
    The action recommended to improve performance. Possible values are Create and Drop.

  • Target of Recommendation
    The partition function or scheme affected by the recommendation. The icon in this column reflects the recommendation to drop or add the Target of Recommendation and whether it is a partition function or scheme.

  • Details
    A description of the Target of Recommendation. Possible values include a range for partition functions, or blank for partition schemes.

  • No. of Partitions
    The number of partitions defined by the recommended partitioning functions. When this function is used with a scheme and then applied to a table, the data in the table is divided into that many partitions.

  • Definition
    The definition of the Target of Recommendation. Click the column to open the SQL Script Preview dialog box, with a script for the recommended action.

Index Recommendations

  • Database Name
    The database containing the objects recommended to be modified.

  • Object Name
    The table related to the recommendation.

  • Recommendation
    The action recommended to improve performance. Possible values are Create and Drop.

  • Target of Recommendation
    The index or view affected by the recommendation. The icon in this column reflects the recommendation to drop or add the Target of Recommendation.

  • Details
    A description of the Target of Recommendation. Possible values include clustered, indexed view, or blank indicating a non-clustered index. Also indicates whether the index is unique.

  • Partition Scheme
    The partition scheme is provided in this column if partitioning is recommended.

  • Size (KB)
    The expected size of the new object that is being recommended. If this column is blank, click See Reports for sizes of existing objects.

  • Definition
    The definition of the Target of Recommendation. Click the column to open the SQL Script Preview dialog box, with a script for the recommended action.

  • Show existing objects
    Select to show all existing objects in the grid, even if no recommendations related to the objects are made by Database Engine Tuning Advisor.

  • See Reports for sizes of existing objects
    Select to view reports that provide the size of existing objects in the recommendations grid.