Since DTA stops unexpectedly, run the following statement to ensure there are no hypothetical indexes left behind:
SELECT *
FROM sys.indexes
WHERE is_hypothetical = 1
Drop any such indexes from your database.
Hypothetical indexes are created by the DTA in the process of its analysis. Provided that the DTA completes gracefully, these indexes are dropped automatically. However, an abrupt DTA stop can cause these indexes to linger and litter your database, even posing a performance hazard!
See:
http://www.graytechnology.com/Blog/post.aspx?id=e21cbab0-8ae2-478e-a027-1b3b14e7d0b9
http://weblogs.sqlteam.com/mladenp/archive/2007/07/16/60257.aspx
__________________________________________________________________________________
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]