Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 DB Tuning Advisor Error

Author  Topic 

chip
Starting Member

14 Posts

Posted - 2009-09-03 : 10:46:45
I setup and ran a trace in Profiler using the tuning template and ran it all day into a table in my database. Now when I try to run DTA on the trace table I get the following error:
"Error: Workload in the input table specified : tblTraceResults could not be opened." I do not understand why since I can open it up fine in Profiler. I give it a session name, choose Table, select the table from the list, and select the database to tune. Any suggestions would be apprecaited. (If I have this in the wrong forum, I apologize)


Chip Dickson
Texas

freddy88008
Starting Member

1 Post

Posted - 2010-04-19 : 14:05:48
Very sad that nobody posted an answer to this question. Very sad.

Fred Mertz
Go to Top of Page
   

- Advertisement -