Home › Server Overview › SQL Server Quick Scan Report › Quick Scan Report – Server Side Trace Running

Quick Scan Report – Server Side Trace Running

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.


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!