Troubleshooting Database Engine Tuning Advisor

Database Engine Tuning Advisor generates a tuning log, by default, for each tuning session. This tuning log contains messages about each event in the workload that Database Engine Tuning Advisor cannot tune. If an event is successfully tuned, Database Engine Tuning Advisor does not record it in the tuning log.

The topics in this section contain information about the tuning log, the messages it contains, and how to delete hypothetical indexes and statistics after a tuning session finishes.

In This Section

Topic Description

About the Tuning Log

Contains information that describes the tuning log and why events are written there.

Why Events Are Not Tuned

Contains information about the reasons why some workload events are not tuned.

Errors and Messages

Contains information about common errors and messages Database Engine Tuning Advisor produces during tuning.

Deleting Hypothetical Indexes and Statistics

Contains information about how to delete hypothetical indexes and statistics that Database Engine Tuning Advisor may leave behind after a tuning session.