Sql profiler removed automatically from Sql server 2008 Developer Instance

sath350163
sath350163 used Ask the Experts™
on
Hello,
I had performance Tools folder earlier in my machine, but is not available now. Not sure what cause it to be removed from my machine.
I have both sql server 2008 Express, SQL Server Developer edition, and SQL Server Denali CTP3 in my machine.
I remember having both SQL Server 2008 Express and Sql Server 2008 Developer edition when ‘Performance Tools’ – Sql profiler was available in my machine earlier.
Not sure if Denali existed in my machine during that time.

Step 1:
This is what I did,
Programs -> Sql server 2008 Developer -> Sql server installation center -> Installation -> New Installation or add features to an existing installation ->
Add Features to an existing instance of Sql Server 2008 R2 -> Clicked on developer instance ->
Shows that only “Management Studio – Basic” as installed and “Management Tools – Complete” unchecked and disabled.


Since I installed all the options for Developer instance and Express Instance, all the features are selected and disabled.
When I click over “Management Tools – Complete”, I get the following in the Description field: "This feature is disabled because the parent feature was installed
by a different edition of SQL Server. To install this feature, upgrade the SQL Server edition of the parent feature by running the SQL Server 2008 R2 Edition Upgrade Wizard.


When I click on Next, it says “To continue, select a feature to install. If all features are already selected, these features are installed. You cannot add additional
features.”

So I thought that removing “Management Studio – Basic” for Express instance, will allow me to add “Management Tools – Complete” for Developer instance.

Please refere to attached image Developer_Instance.png to see the features installed under Developer instance in my machine.

Step 2:
So I did this,
Programs -> Sql server 2008 Express R2 -> Configuration Tools -> Sql Server Installation Center -> Installation ->
“New installation or add features to an existing installation” -> Add Features to an existing instance of Sql Server 2008 R2“ -> Clicked on Express instance ->
shows ”Management Tools – Basic” as installed and disabled. I do not see “Management Tools – Complete” because I selected Express instance.


Since I installed all the available options for Express instance, all the features are selected and disabled.
I’m not sure how to remove the “Management Tools – Basic” that is available under Express instance.
When I click on Next, it says “To continue, select a feature to install. If all features are already selected, these features are installed. You cannot add additional features.”

Please refer to attached image Express_Instance.png image to see the features installed under Express instance in my machine.

Given this setup, how can I get “Performance Tools” to appear for Developer instance?

Thanks!
Developer-Instance.png
Express-Instance.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
lcohanDatabase Analyst
Commented:
Under Management Tools Basic there is a MAnagelemt Tools Complete and check that box.

BTW - Did you started a SQL SSMS on that machine and checked Tools menu option?? SQL Profiler should be listed there and available for use as far as I know even with the Express

Author

Commented:
"Management Tools Complete" is disabled. So there is no way for me to select it.
And I do not see Sql profiler in SSMS Tools menu.

Thanks!
Database Analyst
Commented:
It may be the Express version installed that buggers your Developer which is actualy an Enterprise (full) SQL Edition. I said above that I think it comes with Express - well sorry and scratch that. If possible I would uninstall SQL 2008 R2 Express and strat reinstall full Developer edition only to see if you can get the Complete Management Studio tools to install.

Author

Commented:
I do see PROFILER.EXE in my PC.
Its located in: C:\Program Files\Microsoft SQL Server\100\Tools\Binn

What should I do to make Sql Profiler avaialble under Programs?
Why doesnt it show up in SSMS -> Under Tools?

Thanks!
Top Expert 2012

Commented:
And I do not see Sql profiler in SSMS Tools menu.
SSMS Express Edition does not support SQL Profiler, that is why you are not seeing it.

Author

Commented:
I uninstalled Sql server 2008 developer instance and re-installed it.
This fixed the issue.
I now see SQL profiler under Tools menu in SSMS.

Thanks for all your suggestions.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial