Post reply

Tuning Advisor will not parse input

  • October 4, 2011 at 9:22 am

    #259898

    I am trying to run the Tuning advisor against a 2008 database. I have used profiler to capture a trace file, I used the tuning template to generate the trace. I have also attempted to place the sql statements in an .sql file.

    I always get the same error on step 1. Error: Failed to parse input XML(DTAEngine).

    I am the dbowner. What am I missing? The error is vague and I have no idea where to look next.

    Thanks

  • October 4, 2011 at 9:24 am

    #1390213

    derrick.pope (10/4/2011)

    I am trying to run the Tuning advisor against a 2008 database. I have used profiler to capture a trace file, I used the tuning template to generate the trace. I have also attempted to place the sql statements in an .sql file.

    I always get the same error on step 1. Error: Failed to parse input XML(DTAEngine).

    I am the dbowner. What am I missing? The error is vague and I have no idea where to look next.

    Thanks

    are the database engine, profiler, and DTA the same version? I believe there are some changes in profiler for R2 which require the R2 tools to parse....

  • October 4, 2011 at 9:51 am

    #1390226

    Both tools are 2008.

    The 2005 tools are installed on this machine as well but I am using the 2008.

    Database Engine Tuning Advisor10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    SQL Server Profiler10.0.1600.22

  • October 4, 2011 at 10:55 am

    #1390249

    Ok. In further test I discovered that I can run the Tuning Advisor on the server using the trace files I had already created. I still cannot run the Tuning Advisor from a workstation connecting to the server.

    Is it a requirement that the tool run on the machine where SQL is running? Should I be able to run the DTA from my machine and if so what steps am I missing to get that to work?

  • October 4, 2011 at 11:02 am

    #1390255

    derrick.pope (10/4/2011)

    Ok. In further test I discovered that I can run the Tuning Advisor on the server using the trace files I had already created. I still cannot run the Tuning Advisor from a workstation connecting to the server.

    Is it a requirement that the tool run on the machine where SQL is running? Should I be able to run the DTA from my machine and if so what steps am I missing to get that to work?

    Is your workstation running 32bit tools while the server is running 64bit tools?

    you should be able to run from your machine, but everything needs to be as close to identical as possible.

  • December 1, 2012 at 6:51 pm

    #1564664

    I resolved the same issue by removing the "GO" statement at the very end of the query that was inserted automatically (usually hidden several line-breaks down).

    [SQL Server 2012 SP1]

  • May 6, 2016 at 8:50 am

    #1877172

    Thanks! Removing the "GO" from the end of the script worked for me also!:-)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply