SQL Server 2005 Performance Dashboard Reports - Professional SQL Server 2005 Performance Tuning - page 474

The default trace is a server-side trace that is on by default for all SQL Server 2005 instances. Microsoft
has predefined over 30 events to be traced, including Object:Created, Object:Deleted , Data File Auto
Grow ,and Data File Auto Shrink . Although 30 events may seem like a lot for a trace, these events are
very lightweight and should not seriously impact the performance of your instance. In almost all cases,
the benefits of the default trace outweigh the minimal overhead imposed.

The default trace contains the following trace events shown in Table 13-1:

Table 13-1: The Default Trace Events

Event ID Event Name

18 Audit Server Starts And Stops

20 Audit Login Failed

22 ErrorLog

46 Object:Created

47 Object:Deleted

55 Hash Warning

69 Sort Warnings

79 Missing Column Statistics

80 Missing Join Predicate

81 Server Memory Change

92 Data File Auto Grow

93 Log File Auto Grow

94 Data File Auto Shrink

95 Log File Auto Shrink

102 Audit Database Scope GDR Event

103 Audit Schema Object GDR Event

104 Audit Addlogin Event

105 Audit Login GDR Event

106 Audit Login Change Property Event

108 Audit Add Login to Server Role Event

Continued