SQL Server 2012 – Tuning Process Exited Unexpectedly (DTAEngine)

database-tuningsql server

I am using Windows Server 2012 x64 and SQL Server 2012.

I am running the Database Tuning Advisor with these settings :

  1. Advisor plan cache.
  2. Database workload master.
  3. Check my database all the tables.

When tool is started after few seconds I am getting :

SQL Server 2012 Tuning process exited unexpectedly. DTAEngine.

After some "googling" I found that I should install Service Pack 1 for SQL Server 2012. So I did that.

Same result.

If someone has experienced something like this please advise me.

Thx for your time.

Best Answer

As per KB 2728419

You have to install atleast SQL Server 2012 + SP1 + CU1.

On a sidenote, CU8 is out as well which is the latest one for SQL Server 2012 SP1.

Also, you need to be a member of SYSADMIN role. DB_OWNER wont work as per the above KB.

Related Question