Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have Microsoft SQL Server 2008 R2 Developer Edition installed on my machine which has Win7 64 bit OS. I am not able see Data Tuning Advisor tool in my SSMS. Before this installation my machine already had SQL server 2008 R2 express edition. I upgraded shared components as well but no success.

One thing I noticed while installing developer edition is that there was no option to choose "Management tools - Complete" it was only "Management tools - Basic". Is this an issue?

Can anybody help me getting this tool?

share|improve this question

migrated from Jun 20 '12 at 13:12

This question came from our site for professional and enthusiast programmers.

I think what Aaron said is correct. Just to ask, though, I assume you don't see an item for DTA in the Start Menu group? – Jon Seigel Jun 20 '12 at 13:19
up vote 2 down vote accepted

You'll have to completely uninstall the client tools portion of your Express instance first, since side-by-side installations of Management Studio Express and Management Studio are not supported - there is no direct upgrade path, it's either one or the other.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.