Database Tuning Advisor - Why Doesn't It Give Me Any Results?

Question

I am trying to use Database Tuning Advisor for the first time.

I believe that I resolved all the problems related to resolving - I need an SHOWPLAN that requires SELECT permission on "DTA_tuninglog", etc.

However, in the "Recommendations" section, it does not show anything.

It definitely works and seems to do the work, and there are no bad looking errors in its output, but recommendations are not given.

I even tried to create a dummy database with a terrible query (many table scans), which will undoubtedly be improved with an index, but it also does not show any recommendations for this.

Perhaps my real question is: how do I know when the DTA is working, and I have some kind of configuration problem due to which it does not produce output?

Does anyone have pointers?

Additional Information:

I use the default settings for "Settings"

Physical Design Structures (PDS) for use in the database: Indexes

Partitioning Strategy for Use: Non-Partitioned

Physical Design Structures (PDS) for storing in a database: Store all existing PDS

Answer 1

, . SQL Server Profiler , " " " ( )" ""