教學課程:Database Engine Tuning AdvisorTutorial: Database Engine Tuning Advisor

適用於: 是SQL Server 否Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

歡迎使用 Database Engine Tuning Advisor 教學課程。Welcome to the Database Engine Tuning Advisor tutorial. Database Engine Tuning Advisor 會檢查在您指定的資料庫中如何處理查詢,之後,它會建議您如何修改資料庫結構 (如索引、索引檢視和資料分割) 來改進查詢處理效能。Database Engine Tuning Advisor examines how queries are processed in the databases you specify, and then recommends how you can improve query processing performance by modifying database structures such as indexes, indexed views, and partitioning.

Database Engine Tuning Advisor 提供兩個使用者介面:圖形化使用者介面 (GUI) 和 dta 命令提示字元公用程式。Database Engine Tuning Advisor provides two user interfaces: a graphical user interface (GUI) and the dta command prompt utility. GUI 可讓您既快又容易檢視微調工作階段的結果, dta 公用程式則可以輕易將 Database Engine Tuning Advisor 功能納入自動微調的指令碼中。The GUI makes it easy to quickly view the results of tuning sessions, and the dta utility makes it easy to incorporate Database Engine Tuning Advisor functionality into scripts for automated tuning. 此外,Database Engine Tuning Advisor 可接受 XML 輸入,對微調處理序提供更多控制權。In addition, Database Engine Tuning Advisor can take XML input, which offers more control over the tuning process.

學習內容What You Will Learn

這個教學課程將告訴您如何導覽 Database Engine Tuning Advisor GUI,以及如何利用這個 GUI 和 dta 公用程式來執行某些基本工作。This tutorial will teach you how to navigate the Database Engine Tuning Advisor GUI, and how to perform some basic tasks with both the GUI and the dta utility. 它包含下列課程:It contains the following lessons:

第 1 課:Database Engine Tuning Advisor 中的基本導覽Lesson 1: Basic Navigation in Database Engine Tuning Advisor
在這個課程中,您將熟悉新的 Database Engine Tuning Advisor GUI,以及學習如何設定顯示選項和配置。In this lesson, you will familiarize yourself with the new Database Engine Tuning Advisor GUI and learn how to set display options and layout.

第 2 課:使用 Database Engine Tuning AdvisorLesson 2: Using Database Engine Tuning Advisor
在這個課程中,您將學會如何使用 Database Engine Tuning Advisor GUI 來執行基本微調工作。In this lesson, you will learn how to perform basic tuning tasks with the Database Engine Tuning Advisor GUI.

課程 3:使用 dta 命令提示字元公用程式Lesson 3: Using the dta Command Prompt Utility
在這個課程中,您將學習如何啟動 DTA 命令提示字元公用程式,以及如何執行簡單的微調命令。In this lesson, you learn how to start the dta command prompt utility and how to run some simple tuning commands.

需求Requirements

這個教學課程是專門針對不熟悉 Database Engine Tuning Advisor GUI 或 dta 命令提示字元公用程式,但是熟悉資料庫概念和結構 (例如索引和索引檢視) 的資料庫管理員而提供。This tutorial is intended for database administrators who are not familiar with the Database Engine Tuning Advisor GUI or the dta command prompt utility, but who are experienced with database concepts and structures, such as indexes and indexed views.

您必須安裝具有 SQL Server 2017SQL Server 2017 範例資料庫的 AdventureWorks2012AdventureWorks2012 (或更新版本)。You must install SQL Server 2017SQL Server 2017 (or a later version) with the AdventureWorks2012AdventureWorks2012 sample database. 為了加強安全性,依預設,不會安裝範例資料庫。To enhance security, the sample databases are not installed by default. 若要安裝範例資料庫,請參閱< 安裝 SQL Server 範例和範例資料庫>。To install the sample databases, see Installing SQL Server Samples and Sample Databases.

完成這個教學課程之後After You Finish This Tutorial

完成這個教學課程中的課程之後,請參閱下列主題,以取得有關 Database Engine Tuning Advisor 的詳細資訊:After you finish the lessons in this tutorial, refer to the following topics for more information about Database Engine Tuning Advisor:

  • Database Engine Tuning Advisor >提供如何利用這個工具來執行工作的描述。Database Engine Tuning Advisor for descriptions of how to perform tasks with this tool.

  • dta Utility >提供有關命令提示字元公用程式的參考資料,以及可用來控制公用程式作業的選擇性 XML 檔案。dta Utility for reference material on the command prompt utility and the optional XML file you can use to control the operation of the utility.

下一課Next Lesson

課程 1:Database Engine Tuning Advisor 中的基本導覽Lesson 1: Basic Navigation in Database Engine Tuning Advisor