Hidden Gems of DEFAULT TRACE in SQL Server

Sergii Syrovatchenko

Rate me:

4.98/5 (16 votes)

21 Mar 2016CPOL4 min read

28.7K

Starting from SQL Server 2005, the default trace is enabled by default on every SQL server. Default trace is a lightweight system trace, which stores a lot of useful information about the changes in the system...

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Sergii Syrovatchenko

Database Administrator DraftKings Inc.

Ukraine

SQL Server DBA/DB Developer with 10+ years of experience in SQL Server 2005-2019, Azure/GCP. Worked on high-load OLTP/DW projects and develops system tools for SQL Server. In depth understanding of SQL Server Engine and experience in working with big databases. Domain knowledge of ERP/CRM, crawlers, gambling and retail sales. Blogger, mentor and speaker at local SQL Server events.

Hidden Gems of DEFAULT TRACE in SQL Server

Views

License

Comments and Discussions