Tuning Advisor will not parse input

Question

Tuning Advisor will not parse input

derrick.pope

SSC-Addicted

Points: 459
More actions
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

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

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

NJ-DBA SSChampion Points: 13834 More actions · Answer 1

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....

derrick.pope SSC-Addicted Points: 459 More actions · Answer 2

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

derrick.pope SSC-Addicted Points: 459 More actions · Answer 3

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?

NJ-DBA SSChampion Points: 13834 More actions · Answer 4

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.

bk 61988 Valued Member Points: 73 More actions · Answer 5

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]

michael brule-478901 SSC Veteran Points: 273 More actions · Answer 6

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