Index tuning

Index tuning

 

  

hi,

I am new to MS SQL Server 2000 and want some advice from the gurus on
performance tuning Indexes.

I have a stored procedure which when run shows CPU utilization of 100%. I
have been trying to look at the indexes and hence used the Index Tuning
Wizard, but it does not suggest any recommendations. Any suggestions on how
I should go about tuning the indexes ?

thanks and regards,

Varsha Savyasachi


MS Sql Server LazyDBA home page