none
Database Engine Tuning Advisor not progressing while in the consuming workload

    Question

  • Database Engine Tuning Advisor not progressing while in the consuming workload, how long will this normally take based on 8 5meg workload files and me selecting a single database to work on. It ran an hour and its still at 0% and I see no activity on the SQL server that would indicate that it actually doing anything.

    Thanks Robert

    Friday, October 04, 2013 9:43 PM

Answers

  • Try the advisor on a smaller workload.

    BOL on the topic: "Understanding Tuning Progress


    You can monitor tuning progress in both the Database Engine Tuning Advisor graphical user interface (GUI) and the dta command prompt utility. Monitoring tuning progress can help you determine whether you are using an effective workload, and it can help you spot problems before significant time is wasted. The following sections explain how to monitor the workload in both user interfaces. This topic also explains the order in which Database Engine Tuning Advisor tunes events when various types of workloads are used.

    Monitoring Tuning Progress with the Graphical User Interface

    When you start analyzing a workload with the Database Engine Tuning Advisor graphical user interface (GUI), the application automatically displays tuning progress on the Progress tab. This tabbed page consists of three panes. The top pane displays an animated graphic and values that change as the tuning session progresses. The middle pane contains details about the progress of tuning. The bottom pane displays the tuning log, which refreshes periodically as tuning progresses so you can monitor the session.

    If you want to stop Database Engine Tuning Advisor before a workload is fully processed, click Stop Analysis on the toolbar. When a session is stopped, Database Engine Tuning Advisor generates the best recommendation possible for the amount of workload consumed. "

    LINK: http://technet.microsoft.com/en-us/library/ms179506(v=sql.105).aspx

    Optimization article:   http://www.sqlusa.com/articles/query-optimization/

     


    Kalman Toth Database & OLAP Architect IPAD SELECT Query Video Tutorial 3.5 Hours
    New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012


    Tuesday, October 08, 2013 6:05 AM