May 21, 2003 at 10:06 am
We have a 120GB SQL 2000 database with all data and logfile on a SAN. When we rebuild indexes we suffer seious performance degradation for our queries. Has anyone else seen this happen elsewhere?
May 21, 2003 at 12:03 pm
Did you change the fill factor when rebuilt the indexes?
May 22, 2003 at 1:22 am
We have tried rebuilding the indexes throughout with a fill factor of 90 (disastrous) and also rebuilding the indexes only on the affected table (77m) rows. Each time we saw degradation from 6 hrs to approx 18 hrs. The database designers have - for reasons unexplained - created this table with 7 (count 'em) non-clustered indexes. The query giving us trouble is a batch process. Each index is at least 5 columns wide, and includes three columns which always contains the same values, and are always the same.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply