SQL Server Performance

Database Tuning Advisor

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by JulesBonnot, Oct 20, 2006.

  1. JulesBonnot New Member

    I am trying to pass a trace file to the Database engine tuning advisor

    Once i click start analysis it errors saying 'failed to parse input xml.' I have tried saving the trace as xml and parsing that to the tuner and as a table. I always get the same error. This does not happen except when i use the output of a trace. Please help.
  2. Adriaan New Member

    Please do not double-post. Are you looking for answers regarding SQL 2005, or regarding SQL 7.0 or 2000?
  3. satya Moderator

    DTA is specific to SQL 2005, will move to relevant forum and Jules please follow as suggested.

    For the error you might need to check the event viewer & SQL error log to see whether any issues on server. If not try the DTA tool from another client's machine.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  4. Luis Martin Moderator

    What OS and SQL do you have?

    Luis Martin

    All in Love is Fair
    Stevie Wonder

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page