Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database Tuning Advisor
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Database Tuning Advisor
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01395052
Message ID:
01395052
Views:
137
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
Map
View

Click here to load this message in the networking platform