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

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