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 Data Collector in SQL Server ?

What are Replication and Database Mirroring in SQL Server ?

What is RAISEERROR in SQL Server ?

What are Some Advantages of Using CTE in SQL Server ?

What is the Difference Between DB Mirroring and Log Shipping in S ...