It is generally a really bad idea to run a server side profiler trace on a production SQL Server because of the performance overhead that it adds.
If you must run a Profiler Trace on a production system, keep the following in mind:
- Run the trace from a remote computer.
- Run only for a small amount of time to catch the data you need.
- Filter the trace results to only catch the items that you are interested in.
- Be sure to turn off the trace when you are done.
Whatever you do, don’t let your Profile Trace run continuously on your SQL Server if you are at all concerned about performance.