April 18, 2012 at 12:20 pm
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!
April 18, 2012 at 12:35 pm
Do you have the folder visible under any of your Programs folders for SQL Server?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 18, 2012 at 2:25 pm
No, I do not see it under any of the Sql server folder under Programs.
Thanks!
April 18, 2012 at 2:31 pm
personal computer or work?
local admin?
have you logged in by chance with the wrong account?
Do you have this file on your computer?
"C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\PROFILER.EXE"
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 18, 2012 at 2:57 pm
personal computer or work? - Work
local admin? - Yes
have you logged in by chance with the wrong account? - No. I have be loggig it the same way for a long time now. I have run sql profiler before from my machine. Nothing
has changed recently.
Do you have this file on your computer?
"C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\PROFILER.EXE" - No do not have this file in my PC
Thanks!
April 18, 2012 at 3:09 pm
Correction: I did find PROFILER.EXE in my PC
Its located in: C:\Program Files\Microsoft SQL Server\100\Tools\Binn
Should I launch that?
How do I make it avaialble under Programs?
Why doesnt it show up in SSMS -> Under Tools?
Thanks!
April 18, 2012 at 10:47 pm
anonymous2009 (4/18/2012)
Correction: I did find PROFILER.EXE in my PCIts located in: C:\Program Files\Microsoft SQL Server\100\Tools\Binn
Should I launch that?
How do I make it avaialble under Programs?
Why doesnt it show up in SSMS -> Under Tools?
Thanks!
It sounds like something tried to uninstall that component and it failed.
Launching profiler.exe is one of the tools components, and you could just run it from that location.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 30, 2012 at 12:18 pm
Thanks!
I did install REDGATE tool in my machine recently. Not sure if that changed something.
May 1, 2012 at 10:26 am
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.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply