 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008running profile trace from query analyzer vs profiler - a performance benefit?
Is there any benefit to running a trace from ssms vs running out from the profiler? I assume there is a big one because the gui does not need to be updated and listbox is not all that efficient and what not. Thank you. Hi Running a trace from QA or SSMS will start a server side trace and you won't have the overhead of the GUI and TEMP disc space profiler uses. This can be significant especially if you run Profiler on the server itself (which is not advisable). For instance, if your TEMP directory is on the system disc then you system may grind to a halt if the disc fills up. If you run a server side trace make sure that the output file is being written to a disc that is not going to affect the database I/O ie. on a different spindle/controller. Once you have the trace output it can be copied onto a different machine and analysed. John > Is there any benefit to running a trace from ssms vs running out from the > profiler? I assume there is a big one because the gui does not need to be > updated and listbox is not all that efficient and what not. Thank you. Wow thanks! > Hi > [quoted text clipped - 21 lines] >> be >> updated and listbox is not all that efficient and what not. Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.