X hits on this document

104 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 views104
Page views104
Page last viewedTue Dec 06 16:19:30 UTC 2016
Pages48
Paragraphs987
Words15822

Comments