The SQL Server default trace

The SQL Server default trace reveals a lot about the recent history of the system. Find out how to troubleshoot common database issues using it.

The SQL Server default trace is useful! The SQL Server default trace (introduced from SQL Server 2005 onwards) is a background trace that runs continuously and records event information that, despite the adverse comments on the web about its value, can be useful in troubleshooting problems. Not only that, but it’s there out-of-the box so […]