Database Engine Tuning Advisor "Failed to parse XML file"

Question

When loading a .sql file in Database Engine Tuning Advisor you get "Failed to parse XML file"

score 2 · Answer 1 · answered Feb 15 '21 at 19:13

2

Remove the "GO" at the end of the query (provided it's just a query).

answered Feb 15 '21 at 19:13

Cameron Castillo

2,712
10
47
77

score 0 · Accepted Answer · answered Apr 11 '17 at 20:29

"Executing the DTA on the execute statement itself of the stored procedure, rather than the full 'Script to New Query Editor - Execute Stored Procedure' given by right clicking it."

Source: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4b9062b8-2f20-4028-8a94-e2166d41de5e/error-parsing-xml-in-database-engine-tuning-advisor?forum=sqldatabaseengine

Database Engine Tuning Advisor "Failed to parse XML file"

2 Answers2