A Few Cool Things You Can Identify Using the Default Trace
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Thu, 05 Apr 2012 06:00:00 UT
Indexed on
2012/04/05
11:38 UTC
Read the original article
Hit count: 398
If you are running an instance of SQL Server 2005 and above then most likely that instance is running the default trace. This default trace is a canned Profiler server side trace that automatically starts up when SQL Server starts. In this article Greg Larsen explains more about the default trace and shows you how to glean some event information from the trace files created by this background trace process.
© SQL Server Central or respective owner
