Using Database Tuning Advisor for individual queries
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:
Select the tuning options as shown below
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):
Leave a Reply