Anyone know where I can find details on why my DTA stopped? It keeps halting on the very first part of the process, "Submitting Configuration Information". And the only error message it's giving me is "Tuning Process exited unexpectedly.(DTAEngine)".
The first time around, I thought it was because of the time limit set on the DTA, so I moved the "Limit Tuning Time". This time, though, it stopped well before the time limit hit, and on the exact same step.
Unfortunately, I can see anything in the SQL Server or SQL Server Agent Logs that gives me a clue on why it's choking on my tuning workload. My original workload isn't terribly huge. It's a trace file based off the Tuning template in Profiler and is less than 19 MB in size.
This is my first time using the DTA, so thoughts would be appreciated. I did have to add the procs and tables to MSDB before I could get DTA to work (for some reason, they're missing in all our instances) and I'm running 2k5 SP1 + hotfix.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog
, and Twitter
.Freelance Writer: ShadowrunLatchkeys: Nevermore
, Latchkeys: The Bootleg War
, and Latchkeys: Roscoes in the Night
are now available on Nook and Kindle.