SQL Server Performance

Syntax-Errors in Database Engine Tuning Advisor

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by bittela, Dec 21, 2007.

  1. bittela New Member

    I have a workload, traced in profiler from exactly 1 database. There could be joins into other databases. When I run the DB Enging Tuning Advisor it stopps often after 40-50% with the error: too many syntax errors in workload. I don't have any idea, what it could be. Can sombody give me an advice? Thanks
  2. Luis Martin Moderator

    Is not a good idea to run DTA with all trace.
    Is better to identify from profiler those long queries, copy and paste into Management Studio and call DTA from there.
    About syntax errors:
    Suppose the following query:
    insert into #table select ........
    DTA does not work with temporary tables. If some query have something like that you have to, once again, copy and paste into MS and transform the query to:
    select ........
    or, create a real table, said #temp = temp.my with appropriates fields and call DTA.

Share This Page