General information
Forum:
Microsoft SQL Server
Title:
Database Tuning Advisor
Environment versions
SQL Server:
SQL Server 2005
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only