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.
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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.