question

Randy Burgess avatar image
Randy Burgess asked

How to find or install Database Engine Tuning Advisor

I have SQL Server 2008 installed on my computer, but I'd like to use the Database Engine Tuning Advisor, which I've used with SQL Server 2005 before.

For the life of me, I cannot figure out how to install DETA, find the feature or add-on, or use this tool.

Nowhere in my Start > Programs menu is this tool, nor is there a menu option for it in my SSMS 2008 application.

How does one find, download, install, or add this application?

sql-server-2008ssas
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Nathan Skerl avatar image
Nathan Skerl answered

Are you using Express by any chance? If so, you won't find it as its not included in that release. Otherwise, you should see it both under Tools menu in Management Studio and also under the start menu in Performance Tools directory (this is for 2008).

Do you see the executable at Microsoft SQL Server\100\Tools\Binn\dta.exe ?

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.