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:
Review all of the available SQL tuning advisors.
Consider how the ADDM comprehensive analysis of database performance can retrospectively identify problem SQL statements.
Review how ADDM tasks are both automatically and manually scheduled.
Consider how ADDM results and findings related to SQL statement performance indicate the need for SQL Tuning Advisor analysis.
Schedule a SQL Tuning Advisor task to analyze SQL statements.
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.
