Can you tune the exec spName?
You really dont need to create a wrokload file/trace. In query analyzer write the T-SQL/query you want to analyze/tune, highlight it, right click and select Analyzze Query in database Tuning...
-R!
>Hi All,
>
>I run a SQL Server profiler in order to create a trc file to be used by the DTA.
>The only event I am caputring is SP:StmtCompleted since I need to tune the content of a stored procedure.
>
>When I point the DTA to the trace file and start the analysis I am getting the followig error message:
>
>The specified workload has no tunable events. Events must be one of the following types:
>SQL:BatchStarting
>SQL:BatchCompleted
>RPC:Starting
>RPC:Completed
>SP:StmtStarting
>SP:StmtCompleted
>
>What am I missing?
>Thanks,
>Daniel
Ricardo A. Parodi
eSolar, Inc.