August 4, 2011 at 4:29 am
Hi Guys,
Any tips or articles on how to use Server side tracing with Performance Monitor the way we can use SQL profiler with Performance Monitor.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
August 4, 2011 at 5:39 am
No difference at all. You run a server side trace output to a file, then you open the output file using Profiler. That's it. You can then open the perfmon counters as well and everything just works.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 4, 2011 at 6:07 am
Grant Fritchey (8/4/2011)
No difference at all. You run a server side trace output to a file, then you open the output file using Profiler. That's it. You can then open the perfmon counters as well and everything just works.
Totally missed out on opening the trc file in profiler.
Thank you very much.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy