Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • DownloadDownload
  • PrintPrint

Section Overview

Image Within this section we will discuss the core SQL tuning activities, using the SQL Tuning Advisor and the ADDM framework. We will explore these specific topics:

Image Review all of the available SQL tuning advisors.

Image Consider how the ADDM comprehensive analysis of database performance can retrospectively identify problem SQL statements.

Image Review how ADDM tasks are both automatically and manually scheduled.

Image Consider how ADDM results and findings related to SQL statement performance indicate the need for SQL Tuning Advisor analysis.

Image Schedule a SQL Tuning Advisor task to analyze SQL statements.

Image Examine the recommendations made by the SQL Tuning Advisor, their rationale, and implement those recommendations to improve performance.


  

You are currently reading a PREVIEW of this book.

                                                                                        

Get instant access to over
$1 million worth of books and videos.

  

Start a Free Trial