|
Home > Archive > MS SQL Data Warehousing > April 2005 > Index Tuning Wizard (Crud?) or just me?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Index Tuning Wizard (Crud?) or just me?
|
|
| marcmc 2005-04-06, 8:01 pm |
| Is it just me or is it that you give it a workload and it recommends the
indexes you already have on your table.
Anybody any experience with this 'tool'?
| |
| Adam Machanic 2005-04-06, 8:01 pm |
| I think it's good for new users with very simple scenarios. Beyond that,
you'll have to do it yourself. It really hasn't proven itself, IMO, to be a
good tool.
If you want to learn how to do this yourself, I recommend reading up at
http://www.sql-server-performance.com , and also picking up a copy of Ken
England's SQL Server 2000 performance tuning book, which is on Digital
Press.
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"marcmc" <marcmc@discussions.microsoft.com> wrote in message
news:19D82523-FF56-4577-AD1A- A7D52C48F455@microso
ft.com...
> Is it just me or is it that you give it a workload and it recommends the
> indexes you already have on your table.
>
> Anybody any experience with this 'tool'?
| |
| marcmc 2005-04-07, 7:01 am |
| So it is crud then.
"Adam Machanic" wrote:
> I think it's good for new users with very simple scenarios. Beyond that,
> you'll have to do it yourself. It really hasn't proven itself, IMO, to be a
> good tool.
>
> If you want to learn how to do this yourself, I recommend reading up at
> http://www.sql-server-performance.com , and also picking up a copy of Ken
> England's SQL Server 2000 performance tuning book, which is on Digital
> Press.
>
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
>
> "marcmc" <marcmc@discussions.microsoft.com> wrote in message
> news:19D82523-FF56-4577-AD1A- A7D52C48F455@microso
ft.com...
>
>
>
| |
| Adam Machanic 2005-04-07, 8:01 pm |
| "marcmc" <marcmc@discussions.microsoft.com> wrote in message
news:EC64077C-B25E-41A4-A34E- 38394CDF4C16@microso
ft.com...
> So it is crud then.
I would rathr use the term, "disappointing" :)
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
| |
| marcmc 2005-04-07, 8:01 pm |
| if crud can be disappointing (and i'm sure it could) then the ITW is
definitely that ;-0
"Adam Machanic" wrote:
> "marcmc" <marcmc@discussions.microsoft.com> wrote in message
> news:EC64077C-B25E-41A4-A34E- 38394CDF4C16@microso
ft.com...
>
> I would rathr use the term, "disappointing" :)
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
>
>
|
|
|
|
|