Performance Tools under sql server 2008 developer vanishes/missing

Question

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 below image 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 below 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!

Answer 1

Updates:

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?

Programs?
Why doesnt it show up in SSMS -> Under Tools?

Thanks!

Answer 2

What should I do to make Sql Profiler avaialble under Programs?

Hello,

With SQL Server 2005 you got a shortcut in Windows Start menu, in SQL Server 2008 it changed, there isn't any long a shortcut, only in SSMS to start the tool.

You can add manually a shortcurt to start menu and also in SSMS you can add external tools manually.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 3

I do not see Sql Profiler or any performance related tools in SSMS menu.

I used to have it earlier.

Answer 4

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.