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, Nombre from CtaCtes where 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.

|||Satya (old friend),

I never had a problem with DTA 2005 and SQL 2000.
If fact, DTA 2005 provide better indexes than ITW.
May be is a Katmai bug.|||So, I have to understand Katmai will not support sql 2000. I'm right?|||

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