Defragmentation best practices

Defragmentation best practices

  • Reorganize indexes with less than 30% fragmentation.

  • Rebuild indexes with 30% or more fragmentation.

  • Rebuild indexes during off peak hours.

  • Ignore indexes that have less than 1,000 pages.

  • Use online rebuilds if possible.

  • If the clustered index is being rebuilt, rebuild all indexes in the table.