All and all you end up with a big bunch of trace files that you can feed to DTA or do further analysis on.
Listing 1: Script of trace definition
-- Create a Queue
declare @rc int
declare @TraceID int
declare @maxfilesize bigint
declare @trc_file_name nvarchar(256)
set @maxfilesize = 5
set @trc_file_name='C:\goals_trc\goals_trc_'
select @trc_file_name=@trc_file_name+ CAST(year(getdate()) as char(4))+'_'+CAST(month(getdate()) as char(2))+'_'+CAST(day(getdate()) as char(2)) +'_'+ CAST(datepart(hh, getdate()) as char(2))
set @trc_file_name=rtrim(@trc_file_name)
--select @trc_file_name
exec @rc = sp_trace_create @TraceID output, 0, @trc_file_name, @maxfilesize, NULL
--if (@rc != 0) goto error
-- Client side File and Table cannot be scripted
-- Set the events
declare @on bit
set @on = 1
--exec sp_trace_setevent @TraceID, 97, 1, @on
--exec sp_trace_setevent @TraceID, 97, 3, @on
--exec sp_trace_setevent @TraceID, 97, 10, @on
--exec sp_trace_setevent @TraceID, 97, 13, @on
--exec sp_trace_setevent @TraceID, 97, 16, @on
--exec sp_trace_setevent @TraceID, 97, 17, @on
exec sp_trace_setevent @TraceID, 122, 1, @on
exec sp_trace_setevent @TraceID, 122, 3, @on
exec sp_trace_setevent @TraceID, 122, 10, @on
exec sp_trace_setevent @TraceID, 122, 13, @on
exec sp_trace_setevent @TraceID, 122, 16, @on
exec sp_trace_setevent @TraceID, 122, 17, @on
exec sp_trace_setevent @TraceID, 10, 1, @on
exec sp_trace_setevent @TraceID, 10, 3, @on
exec sp_trace_setevent @TraceID, 10, 10, @on
exec sp_trace_setevent @TraceID, 10, 13, @on
exec sp_trace_setevent @TraceID, 10, 16, @on
exec sp_trace_setevent @TraceID, 10, 17, @on
exec sp_trace_setevent @TraceID, 12, 1, @on
exec sp_trace_setevent @TraceID, 12, 3, @on
exec sp_trace_setevent @TraceID, 12, 10, @on
exec sp_trace_setevent @TraceID, 12, 13, @on