CHAPTER 28 ■ PERFORMANCE TUNING
Figure 28-17. Connect to Server dialog box
The main screen now appears, showing the connected SQL Server instance in the left Session Monitor window, and the General configuration tab in the right window (see Figure 28-18). In the General tab, you can select the file containing the SQL you wish to tune by selecting the File option under the Workload section, in this case C:\Apress\ProductsByLocation.sql. You also select the database where the tuning recommendations should be focused by selecting the checkbox next to the AdventureWorks database.
Figure 28-18. General options for the Database Engine Tuning Advisor