Wednesday, March 21, 2012

Database Engine Tuning Advisor 2005

Do bad indexes hinder performance? if so will the Database Engine Tuning
Advisor detect them and recommend their removal?
Howard
> Do bad indexes hinder performance? if so will the Database Engine Tuning
Yes, absolutely ,yes. You would want to remove unnecessary indexes
> Advisor detect them and recommend their removal?
Well , I have not played yet with Tunning Advisor of SQL Server 2005 but I
can say for SQL Server 2000 I'd not rely on its recommendations because it
is not always true.
"Howard" <howdy0909@.yahoo.com> wrote in message
news:OteKrBTUGHA.2244@.TK2MSFTNGP14.phx.gbl...
> Do bad indexes hinder performance? if so will the Database Engine Tuning
> Advisor detect them and recommend their removal?
>
|||What do you mean by a bad index? an extra index that's not beign used? a
redundent index? an index with fragmentation issues?
-Paul Nielsen
SQL Server MVP
www.SQLServerBible.com
"Howard" <howdy0909@.yahoo.com> wrote in message
news:OteKrBTUGHA.2244@.TK2MSFTNGP14.phx.gbl...
> Do bad indexes hinder performance? if so will the Database Engine Tuning
> Advisor detect them and recommend their removal?
>
|||an extra index that's not being used or a redundent index.
I trying to understand how indexes work.
"Paul Nielsen (MVP)" <pauln@.sqlserverbible.com> wrote in message
news:%23JH%23ZUWUGHA.4952@.TK2MSFTNGP09.phx.gbl...
> What do you mean by a bad index? an extra index that's not beign used? a
> redundent index? an index with fragmentation issues?
> -Paul Nielsen
> SQL Server MVP
> www.SQLServerBible.com
>
> "Howard" <howdy0909@.yahoo.com> wrote in message
> news:OteKrBTUGHA.2244@.TK2MSFTNGP14.phx.gbl...
>
|||Yes - if you choose not to keep any existing PDS it will recommend to
drop unused indexes. Note that the tool makes this decision based on
the workload you specify as input.DTA has been run on various
enterprise workloads and the feedback has been very positive
Thanks
Howard wrote:[vbcol=seagreen]
> an extra index that's not being used or a redundent index.
> I trying to understand how indexes work.
>
> "Paul Nielsen (MVP)" <pauln@.sqlserverbible.com> wrote in message
> news:%23JH%23ZUWUGHA.4952@.TK2MSFTNGP09.phx.gbl...

No comments:

Post a Comment