sath350163
asked on
Sql profiler removed automatically from Sql server 2008 Developer Instance
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!
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!
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.
SSMS Express Edition does not support SQL Profiler, that is why you are not seeing it.
ASKER
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.
This fixed the issue.
I now see SQL profiler under Tools menu in SSMS.
Thanks for all your suggestions.
ASKER
And I do not see Sql profiler in SSMS Tools menu.
Thanks!