dbTalk Databases Forums  

Receiving "no tunable events" message from DTA; unsure why

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Receiving "no tunable events" message from DTA; unsure why in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
bchristensenpager@gmail.com
 
Posts: n/a

Default 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....


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.