Capturing, Measuring, and Replaying a Workload Using SQL Profiler - Professional SQL Server 2005 Performance Tuning - page 325

DatabaseName

❑

DatabaseID

❑

ClientProcessID

❑

HostName

❑

❑ ServerName

❑ BinaryData

❑ SPID

❑ StartTime

EndTime

❑

IsSystem

❑

NTDomainName

❑

NTUserName

❑

Error

❑

If the workload file does not contain the above events and columns, the replay will return an error and
stop replaying the file. For example, if you use the SQL Profiler Standard trace template to collect data,
you will see the error message in Figure 10-3 from SQL Profiler when you replay the trace.

Figure 10-3

The easiest way to meet the minimum requirements for event classes and data columns is to use the SQL
Profiler TSQL_Replay trace template directly or to add more event classes in addition to the TSQL_Replay
trace template.