Adding disks when devices are full

Simply adding disks and recreating indexes when partitions are full may not solve load-balancing problems. If a physical device that holds a partition becomes completely full, the data-copy stage of recreating an index cannot copy data to that physical device.

If a physical device is almost completely full, recreating the clustered index does not always succeed in establishing a good load balance.