Performance Monitor for Indexes

I have a SQL Server 2000 database with numerous indexes. The database
developers have reworked the indexes to increase database performance.
This database has Windows 2003 as the operating system on this server.
What are the performance monitor counters that I should add to my perfmon job
to collect statistic before and after the indexes have been modified?
Please help me with this task.
Thanks,Indexing will have most impact on disk io, so I would monitor PhysicalDisk:
%Read time and PhysicalDisk %Write time for each disk. You should also look
at CPU changes by monitoring the cpu counters, and also Average Disk Queue
length.
My preferred approach in this case though is to use SQL Profiler and run a
trace before adding indexes and trace to a table. Then add your indexes and
run the same workload through.
Then query your trace tables to find how your longest runnnig queries before
indexing have improved. You will be able to examine duration of query, reads,
writes and cpu. This will give you more information and suggest to you
queries that are still not performing well after you apply your indexing
script.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Joe K." wrote:
> I have a SQL Server 2000 database with numerous indexes. The database
> developers have reworked the indexes to increase database performance.
> This database has Windows 2003 as the operating system on this server.
> What are the performance monitor counters that I should add to my perfmon job
> to collect statistic before and after the indexes have been modified?
> Please help me with this task.
> Thanks,