Click here to Skip to main content
15,443,778 members
Articles / Database Development

Tagged as

Stats

24.1K views
18 bookmarked

Hidden Gems of DEFAULT TRACE in SQL Server

Rate me:
Please Sign up or sign in to vote.
4.98/5 (16 votes)
21 Mar 2016CPOL4 min read
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
Database Administrator DraftKings Inc.
Ukraine 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.

Comments and Discussions