Often times, instead of tuning an entire database, we are interested in performance tuning a single offending query. This can be accomplished by applying the tuning wizard to a specific query as shown below:

From within Query Analyzer, select ‘Analyze Query in DTA’ as shown below:

from_within_query_window 

Select the tuning options as shown below

available_tuning_options

Estimated Improvements

After you run the DTA, the advisor will point out the total improvements you can see if you implement its recommendations (as shown below):

improvements_from_DTA

Anuj holds professional certifications in Google Cloud, AWS as well as certifications in Docker and App Performance Tools such as New Relic. He specializes in Cloud Security, Data Encryption and Container Technologies.

Initial Consultation

Anuj Varma – who has written posts on Anuj Varma, Hands-On Technology Architect, Clean Air Activist.