If you have to use Profiler on your production SQL Servers – filter as much as you can, configure profiler from a remote machine and do not save the profiler trace on the same production box. Rather prefer using server-side trace.
Note: Profiler is deprecated now, start using Extended Events – they are very light weight.

Leave a Reply