DTA Compatibility
Phil move this post to SQL 2005 forum.
I suppose my lack of English was the reason, so I post it again.
I'm working with DTA Katmai SQL Server 2008.
Runing the next query using DTA:
selectLTrim(RTrim(CodCtaCte))as CodCtaCte, Nombrefrom CtaCteswhere CuePrefi='C'orderby Nombre
with SQL Server 2000 SP4 instance, I got this error:
"Tuning process exit unexpectedly"
Now, the same DTA and query but using SQL Server 2005 SP2 instances, works fine.
Both insances are in the same Server with Windows 2003.
Any clue?
Luis
I guess there was bug within SQL 2005 too working with DTA as that was found to be a bug in DTA in dealing with indexed views, in your case I woudln't take a guess that you are using Indexed views or any of them are involved or not.
From your posting it seems that DTA Katmai against Shiloh fails while DTA Katmai against Yukon works.Is this correct?
Potentially this is hitting a bug when DTA tries to analyze the showplan_parsing output for a query . This is not a problem in SQL Server 2005 since we use the more robust showplan_xml interface.
Can you check if there are any dtaengine mini dumps in the ErrorDumps Folder ? (typically the path is C:\Program Files\Microsoft SQL Server\100\Shared\ErrorDumps) .If so we can take a look at the minidumps
Please let me know
Manoj
Your first question is correct.
Also there is no problem with DTA 2008 and SQL 2005.
There is nothing in ErrorDumps.
Thanks.
Hi Luis
Given that there are no user mode dumps the best way to proceed would be to file the problem as a bug using the connect program. It will be easier to debug if you have a representative database and workload.
Let us know if you have any questions on how to proceed
Manoj
