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?

more ▼

asked Feb 01, 2010 at 01:42 AM in Default

Randy Burgess gravatar image

Randy Burgess
22 2 2 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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 ?

more ▼

answered Feb 01, 2010 at 04:30 AM

Nathan Skerl gravatar image

Nathan Skerl
432 1 1 3

I am not using Express. I don't see dta.exe in that folder. I'm just trying to figure out how to add it in there.
Feb 01, 2010 at 03:22 PM Randy Burgess
  • which version of 2k8 you have installed?
  • are you a sysadmin on the server?
- can you type a query, r-click in Mgmt Studio, and choose "Analyze Query in Database Engine..." ?
Feb 01, 2010 at 11:17 PM Nathan Skerl

I do not get the option to "Analyze Query in Database Engine" in the query editor.

Application Info
Microsoft SQL Server Management Studio 10.0.2531.0
Microsoft Data Access Components (MDAC) 3.85.1132
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3603
Operating System 5.1.2600
Feb 02, 2010 at 12:39 PM Randy Burgess
I am a sysadmin on the server
Feb 02, 2010 at 12:47 PM Randy Burgess
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 01, 2010 at 01:42 AM

Seen: 2145 times

Last Updated: Feb 01, 2010 at 01:48 AM