Index Performance Monitor Counter

I have a SQL Server 2000 database that I have clean up duplicates indexes
and numerous other unneeded indexes.
What are good performance monitor counters to show the database running
better
without these indexes?Joe K. wrote:
> I have a SQL Server 2000 database that I have clean up duplicates
> indexes and numerous other unneeded indexes.
> What are good performance monitor counters to show the database
> running better
> without these indexes?
Record a profiler trace of typical traffic before and after the change.
That way you can also look at ITW's suggestions for indexes to drop /
created.
Kind regards
robertsql

Index Performance Monitor Counter

I have a SQL Server 2000 database that I have clean up duplicates indexes
and numerous other unneeded indexes.
What are good performance monitor counters to show the database running
better
without these indexes?
Joe K. wrote:
> I have a SQL Server 2000 database that I have clean up duplicates
> indexes and numerous other unneeded indexes.
> What are good performance monitor counters to show the database
> running better
> without these indexes?
Record a profiler trace of typical traffic before and after the change.
That way you can also look at ITW's suggestions for indexes to drop /
created.
Kind regards
robert

Index Performance Monitor Counter

I have a SQL Server 2000 database that I have clean up duplicates indexes
and numerous other unneeded indexes.
What are good performance monitor counters to show the database running
better
without these indexes?Joe K. wrote:
> I have a SQL Server 2000 database that I have clean up duplicates
> indexes and numerous other unneeded indexes.
> What are good performance monitor counters to show the database
> running better
> without these indexes?
Record a profiler trace of typical traffic before and after the change.
That way you can also look at ITW's suggestions for indexes to drop /
created.
Kind regards
robert