Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anonymous2009
Starting Member
8 Posts |
 Posted - 2012-04-18 : 14:58:03
|
| 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! |
|
|
anonymous2009
Starting Member
8 Posts |
Posted - 2012-04-18 : 17:24:15
|
| I do see PROFILER.EXE in my PC. Its located in: C:\Program Files\Microsoft SQL Server\100\Tools\BinnWhat should I do to make Sql Profiler avaialble under Programs?Why doesnt it show up in SSMS -> Under Tools?Thanks! |
 |
|
|
|
|
|
|
|
Performance Tools under sql server 2008 developer