Post reply

Error running 'Database Tuning Advisor'.

  • September 11, 2009 at 10:29 am

    #226000

    Hello Friends

    I was running the DTA and getting an error while the DTA is trying to consume the file. Can you please suggest how to get rid of the trouble.

    What I did...

    (1) Executed a profiler and saved the 'profiler' output in a table: work_load_file in [master] DB. (just I kept). Ran againt the server.

    (2) Created a 'work load' file in the "d:\" with name as "work_load_file.trc".

    (3) Select the appropriate database to tune..(chose msproduct).

    (4) Checked the "save tuning log".

    In the progress tab, the error is coming as::

    "Error: Unable to open input file specified : d:\work_load_file.trc".

    Any suggestions would be helpful.

    Note: I was trying to make myself aware of this 'performance tool'. This is not related to any project. At my home I tried and got this error. Any suggestions to run the tool for the first time would help me to understand the functions and usage!!

    Thanks.

  • September 11, 2009 at 10:46 pm

    #1052660

    First, you probably shouldn't have created the trace table in the master database, but since you did, oh well.

    You should be able to consume the data from the table directly without having to export it to a file first. I have done that myself and it worked.

  • September 12, 2009 at 11:22 am

    #1052720

    Lynn,

    Thought I couldn't understand properly from your response how to fix my problem, but thanx for your response.

    Can you suggest any doc(PDF) so that I can go through the same before jumping into DTA..?

    Sorry to giving you additional trouble but this will be helpful for me.

    Thank you,

    Thanks.

  • September 12, 2009 at 11:53 am

    #1052725

    I'd start with BOL (Books Online).

  • November 9, 2009 at 2:58 am

    #1076553

    Try Saving the Workload file with "Windows 1252" encoding.

    It looks like DTA can't read/parse workload files in anything other than windows 1252... sadly

  • November 9, 2009 at 3:55 am

    #1076569

    refer this doc.

    hope it will help u

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

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

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