Currently I am confronted with a production SQL Server database where someone had added almost all missing index proposals from DTA.
Form How to determine if an Index is required or necessary I have learned, that there are DMV views, which can be used to defer information about actual index usage as well as missing indexes.
DTA on the other side requires planning when to run the profiler, select what to profile and has some impact on performance while running.
My impression is that using DTA as first step tuning tool is simply a waste of time and as its results don't cover the complete database usage, are hard to interpret by novices and can lead to adding too much indexes with negative impact on write performance, while Data collection via DMV requires little preparation and covers nearly the whole usage of the database since the last restart.
My question focuses on which strategy to propose to the management. I want to focus on evaluation the DMV views in the first step and ignore DTA completely.