Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Diligent DBAs often employ mass defragmentation on their SQL Servers through self-made scripts or maintenance plans. Unfortunately, this approach falls short because no two tables or indexes have identical tuning requirements. Using this mass approach can also be problematic , because it often acquires unnecessary table and index locks during defragmentation, which can cause deadlocks.

...