June 2, 2006 at 8:24 am
All,
I have a sql 2000 database with the latest service pack, and it has 9 .ndf files.
The defragmention level is 33 % on average for more than half of the tables in that database. And the number of rows modified since the last run of the optmization job is 0 for most of them but even then the fragmentation level is 33 %.
Is this because we are using lot of ndf files ? or it is because lots of rows are being changed every day ?
Thanks.
June 2, 2006 at 9:29 am
I think it is mainly due to inserts, updates, and deletes. We have alot of modification on our databases so I have to run index defrag /re-index every week.
Max
June 5, 2006 at 3:58 am
I see that in our environment for tables will a small rowcount. Apparently if it only takes a fraction of a page it shows as fragmented.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply