X hits on this document

161 views

0 shares

0 downloads

0 comments

37 / 48

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

671

Document info
Document views161
Page views161
Page last viewedSat Jan 21 16:23:15 UTC 2017
Pages48
Paragraphs987
Words15822

Comments