SQL Server 2005 has a basic trace that is created when you install SQL Server and starts on start-up. You could remove this trace if you wanted to, but since you didn't know about it, it obviously isn't negatively affecting performance. This is also what many of the Management reports get their data from.

Profiler is actually just a GUI interface on top of server-side tracing. You could check out the Profiler video's on http://www.jumpstarttv.com where I explain how to use Profiler to generate a script for a server-side trace.

You can also lookup server-side trace in BOL.

• This reply was modified 5 years, 1 month ago by  Jack Corbett.
• This reply was modified 4 years, 7 months ago by  Dave Convery.