DaveWentzel.com            All Things Data

Default Trace

This is the new name for the old BlackBox trace under older versions of SQL Server, although it is not really a direct replacement because they do work differently.  

SELECT *

 

FROM fn_trace_getinfo(default);

GO
 
Trace files are kept in the \LOG file by default. 
 
EXEC master.dbo.sp_configure 'allow updates', 1;

GO

EXEC master.dbo.sp_configure 'show advanced options', 1;

GO

EXEC master.dbo.sp_configure 'default trace enabled', 0;

GO

RECONFIGURE WITH OVERRIDE;

GO

EXEC master.dbo.sp_configure 'show advanced options', 0;

GO

 

Profiler Tips

Performance Page

Add new comment