Posts in Database Administration

How to Kill a Profiler Trace

Reprinted with permission from owner. Original at

Using Profiler to run a trace can be an invaluable tool for troubleshooting performance problems with T-SQL code. Occasionally something happens to the connection between Profiler and the SQL Server where the trace is running and you can no longer manage the trace from the profiler window. Because an errant trace can impact performance, this situation needs to be rectified ASAP. To get information on the traces being run on a server, you can issue the following query.
Keep reading…

We're Here To Help.

    Database problem? Tell us a little bit about it.






    * Required