Export (0) Print
Expand All

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.

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft