Indexes with Duplicate Columns

I have a SQL Server 2000 database.
This database has indexes with numerous duplicate columns and these
columns are not used for covered indexes.
A lot of the indexes were created initially.
What is the best way to show database performance analysis before and after
deleting these indexes with duplicate columns?
Please help me with this performance issue.
Thank You,I use set statistics IO on and compare the io before and after.
I also run timings like this
declare @.counter int
declare @.getdate datetime
set @.getdate=getdate()
set @.counter=1
while @.counter < 100
begin
EXEC MY_Proc
select @.counter=@.counter+1
end
select datediff(ms, @.getdate, getdate())
so I have an idea of how long 100 iterations took
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:8E832B5C-FB88-4E97-8288-443AEA0A9E8D@.microsoft.com...
>I have a SQL Server 2000 database.
> This database has indexes with numerous duplicate columns and these
> columns are not used for covered indexes.
> A lot of the indexes were created initially.
> What is the best way to show database performance analysis before and
> after
> deleting these indexes with duplicate columns?
> Please help me with this performance issue.
> Thank You,|||Joe K. wrote:
> I have a SQL Server 2000 database.
> This database has indexes with numerous duplicate columns and these
> columns are not used for covered indexes.
> A lot of the indexes were created initially.
> What is the best way to show database performance analysis before and
> after deleting these indexes with duplicate columns?
> Please help me with this performance issue.
> Thank You,
You can use the profiler to record a typical workload before changing
indexes and to get timings (and execution plans). You can then use this
workload to get suggestions from the ITW. You can then implement them or
implement different changes. Profile again and compare timings and
execution plans.
Kind regards
robert