Receiving "no tunable events" message from DTA; unsure why -
05-19-2008
, 05:03 PM
I am attempting to submit a trace table to the Database Engine Tuning
Advisor for analysis. Each attempt appears to process for about 45
minutes or so (the trace table comprises about 4.5 million rows), and
then returns with the message:
"The specified workload(file or table) has no tunable events. Events
must be one of the following types - SQL:BatchStarting,
SQL:BatchCompleted, RPC:Starting, RPC:Completed, SP:StmtStarting or
SP:StmtCompleted for workload trace file or table."
I can open the table without issues using SQL Profiler, both
independently and through the Preview Workload Table feature in the
General tab of the tuning session, and can see SP:StmtCompleted events
within the first 100 rows.
This message is generated using both the GUI and console versions of
the tool.
Any ideas as to what the problem might be, or suggestions for further
troubleshooting tasks, will be warmly appreciated.... |