sp_Blitz® Result: Default Trace Contents

SQL Server’s default trace (which is, as you might guess by the name, enabled by default) captures basic system events to a trace file. 

This part of our SQL Server sp_Blitz® script checks how much history is being stored in the default trace, and where it’s being kept.

To READ THE CONTENTS

Here’s some helpful utility queries on how to get file growth events, query warnings, security violations, and more:

• Default Trace Queries by Feodor Georgiev at Simple Talk
• Beginner’s Guide to the Default Trace by Adam Haines (SQLServerCentral registration required)

Return to sp_Blitz or Ask Us Questions