Tuesday, February 14, 2012

database tunning advisor 2005 question

i ran an analysis of a database using the tunning adviser. I pointed
it to some trace files I took. It provided me with a list of new
indexes along with the various reports.
what i have not found is the linkage between the most costly queries
from the trace and the new index recommendations.
did i miss this? Let's say i only want to implement the top 3 index
recommendations based on their ability to minimize the most expensive
query operations...
does the tuning advisor provide this? or do i have to "connect the
dot" between the 2 myself?
Thanks.Hi
The tuning advisor provides recommendation using the sample provided. If you
only want to have the specific queries tuned then you could modify the
sample, although only tuning specific queries may have a detremental effect
elsewhere.
If you had a standard benchmark test then you can judge the effects of your
query tuning by running the test before and after the indexes have been
applied.
John
"kent@.kaeservices.com" wrote:
> i ran an analysis of a database using the tunning adviser. I pointed
> it to some trace files I took. It provided me with a list of new
> indexes along with the various reports.
> what i have not found is the linkage between the most costly queries
> from the trace and the new index recommendations.
> did i miss this? Let's say i only want to implement the top 3 index
> recommendations based on their ability to minimize the most expensive
> query operations...
> does the tuning advisor provide this? or do i have to "connect the
> dot" between the 2 myself?
> Thanks.
>