Database Engine Tuning advisor "Performing analysis" fails with STOPPED

Question

Whenever I run Database Engine Tuning advisor I get no recommendations (even when I set up scenarios with table scans that would be avoided by an index).

I see "Performing analysis" shows as "Stopped" with no errors or explanation. What is the cause of this and how do I correct?

Answer 1

This might be a SSMS/SQLServer versionin compatibility issue. I previously used SSMS2017 on the client against SQL2012 on the server. Running my DTA from the sqlserver itself (where the versions match) I get a successful output.

Answer 2

My solution to this exact problem was to only select (under the General tab) the tables used in the select query.