What are the Events On Default Trace in SQL Server ?

The default SQL Server trace from SQL Server 2005 onwards is a background trace that runs continuously and records event information that can be useful in troubleshooting problems. Though the list is long, the following are captured by default trace..

  • Data file auto grow
  • Data file auto shrink
  • Database mirroring status change
  • Logfile auto grow
  • Logfile auto shrink
  • Error log
  • Missing Column Statistics
  • Missing Join Predicate
  • Object Altered
  • Object Created
  • Object Deleted
  • Server Memory Change

Apart from these many other SQL Server Security Auditing events are also captured like Add DB user event, DBCC event, Login Failed, Backup/Restore event, Server Starts and Stops and many more.

You May Interest

What is CHECKPOINT Process in the SQL Server ?

What is CTE in SQL Server ?

How to Restart SQL Server in Single-User Mode ?

Making a MS SQL Offline Database Online

Differences Between Stored Procedure and Function in MS SQL