HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Microsoft SQL Server 2008 R2 Developer Edition Data Tuning Advisor tool

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
advisor2008sqltuningmicrosoftdeveloperservereditiondatatool

Problem

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?

Solution

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.

Context

StackExchange Database Administrators Q#19556, answer score: 2

Revisions (0)

No revisions yet.