locked
Can't Open Database Tuning Adviser Tool RRS feed

  • Question

  • Hello,

                This morning I tried to use DTA tool, but when In try to connect following error occured

    When I proceed by clicking OK I got following error

    I tried different solutions that are available on forum (running script) but still I didn't managed to resolve the issue. Please let me know, if their is any alternative to solve this issue. Thanks in advance.

    Tuesday, August 21, 2012 1:58 PM

Answers

  • Hi Kriuk,

    When we are running DTA, it will looking for the following in MSDB:Tables:
    'DTA_input',
    'DTA_progress',
    'DTA_output',
    'DTA_tuninglog',
    'DTA_reports_database',
    'DTA_reports_partitionfunction',
    'DTA_reports_partitionscheme',
    'DTA_reports_table',
    'DTA_reports_tableview',
    'DTA_reports_query',
    'DTA_reports_querytable',
    'DTA_reports_querydatabase',
    'DTA_reports_index',
    'DTA_reports_queryindex',
    'DTA_reports_column',
    'DTA_reports_indexcolumn',
    'DTA_reports_querycolumn'

    Stored Procedures:
    'sp_DTA_add_session',
    'sp_DTA_delete_session',
    'sp_DTA_help_session',
    'sp_DTA_update_session',
    'sp_DTA_get_tuninglog',
    'sp_DTA_update_session',
    'sp_DTA_get_session_report',
    'sp_DTA_get_tuninglog',
    'sp_DTA_get_session_tuning_results',
    'sp_DTA_set_interactivestatus'

    These objects were missing from the server that was failing, you can scripted them from the server that was working, and Database Tuning Advisor will work.


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by kriuk Friday, August 24, 2012 2:09 PM
    Thursday, August 23, 2012 7:11 AM

All replies

  • Hi,

    Can you provide the followings please?

    • OS version + patch level,
    • sql server version + patch level,
    • DTA version + patch level
    • DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS output.

    Janos


    There are 10 type of people. Those who understand binary and those who do not.

    My Blog | Hire Me

    Tuesday, August 21, 2012 3:27 PM
  • Hi Janos,

                    I'm using Windows Server 2008 SP1 and sql server: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1), and output of DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS says Commands completed successfully. 


    Krishna

                    

    Tuesday, August 21, 2012 6:47 PM
  • Hi,

    Eval edition allows 6 month trial. Is that possible that you are over 6 months? Did you try to update SQL Server with the latest SP?

    Janos


    There are 10 type of people. Those who understand binary and those who do not.

    My Blog | Hire Me

    Tuesday, August 21, 2012 7:21 PM
  • Hi,

           I just Installed Eval edition last month. Even in Sql Server 2012 Eval edition I'm facing same problem.

    Krishna 


    • Edited by kriuk Tuesday, August 21, 2012 8:00 PM
    Tuesday, August 21, 2012 7:59 PM
  • Can zou check this thread please? http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/287bf86c-ec72-410c-b916-933c687c6269

    It may help.

    Janos

     

    There are 10 type of people. Those who understand binary and those who do not.

    My Blog | Hire Me

    Tuesday, August 21, 2012 8:26 PM
  • Hi Kriuk,

    When we are running DTA, it will looking for the following in MSDB:Tables:
    'DTA_input',
    'DTA_progress',
    'DTA_output',
    'DTA_tuninglog',
    'DTA_reports_database',
    'DTA_reports_partitionfunction',
    'DTA_reports_partitionscheme',
    'DTA_reports_table',
    'DTA_reports_tableview',
    'DTA_reports_query',
    'DTA_reports_querytable',
    'DTA_reports_querydatabase',
    'DTA_reports_index',
    'DTA_reports_queryindex',
    'DTA_reports_column',
    'DTA_reports_indexcolumn',
    'DTA_reports_querycolumn'

    Stored Procedures:
    'sp_DTA_add_session',
    'sp_DTA_delete_session',
    'sp_DTA_help_session',
    'sp_DTA_update_session',
    'sp_DTA_get_tuninglog',
    'sp_DTA_update_session',
    'sp_DTA_get_session_report',
    'sp_DTA_get_tuninglog',
    'sp_DTA_get_session_tuning_results',
    'sp_DTA_set_interactivestatus'

    These objects were missing from the server that was failing, you can scripted them from the server that was working, and Database Tuning Advisor will work.


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by kriuk Friday, August 24, 2012 2:09 PM
    Thursday, August 23, 2012 7:11 AM