I think the DTA still needs a lot of work on behalf of the SQL Server dev team.
I have only been able to get it to work on individual queries with no temp tables and no parameters - just hard-coded values!
Still useful if you have a gigantic query and you want to get index recommendations on it, but still not nearly enough!
The claim that the DTA can analyze trace workloads is simple bogus, at least in my experience.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]