Table Fragmentation level...

  • 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.

  • 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

  • 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