SQL Profiler from a remote machine

[mchatz13]

Hi,

I ave a sql server that has been getting slower, and need to run the Profiler to see where everything is slowing down. I do not want to run the profiler on the server that is slowing because I am afraid that it will adversaly affect that server more. If I run the Profiler on another machine and trace the slow server where does most of the load sit?

thanks

mc

 

[MaffewW]

I think most of the load will sit on the server anyway as thats where the trace is actually happening, running it on a remote machine will probably make little or no difference. Try and run short traces at times which you need to monitor most.

 

[SQLBaby]

Always trace through remote and save the trace file also on remote computer, if you will trace itself on the same server it will be more slow and will effect the performance.

 

[mchatz13]

Thanks,

We decided to either run the trace on the log files or on the backup servers that via log shipping every 5 minutes should give us an accurate trace of the production servers whilst not affecting their performance.

mc