September 11, 2015 at 7:57 am
All:
We are using SQL Server 2008 R2. When I got my new computer, I had SSMS already installed, but there was no SQL Server Profiler installed. I tried to search the internet for the download, but can't find anything other than "it is part of the Management Tools" and I need to check "Complete" instead of "Basic".
However: as I did not install the original SSMS, I am not sure how to get this installed.
Would anyone be able to give me some information on what is needed to get SQL Server Profiler installed on my local machine?
Thanks....
September 11, 2015 at 9:16 am
You need to re-run the setup from the developer, enterprise, or standard media and choose the standalone option and add the feature.
September 11, 2015 at 10:40 am
Thank you for the suggestion, but I do not have a copy of the medium used. It was installed by our corporate software team prior to me getting the laptop. Is this not something I can do myself without having to submit a request for a software package they claim isn't something they manage (I did ask)?
September 11, 2015 at 11:26 am
I think you can download an evaluation edition of SQL Server and only install the management tools which will include profiler.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 16, 2015 at 6:28 am
Thank you for the help. Out of curiosity: does that "evaluation" copy have to be the same version we are using (SQL Server 2008 R2), or can it be newer versions?
September 16, 2015 at 7:35 am
I believe the the recommended practice has always been to use the same version of profiler as the server you are going to trace. Also I know there is a nice GUI for profiler, but you could always use Extended events through the command line.
September 16, 2015 at 7:35 am
Can be a newer edition as the tools are usually backwards compatible. Profiler is anyway.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply