Solution Brief : SQL Defrag Manager

What Is Fragmentation

When changing data in a database, the database and its indexes become fragmented. As indexes become fragmented, ordered data retrieval becomes less efficient. Inefficient data retrieval reduces the performance of the database. There are several types of fragmentation that can occur. These types of fragmentation impact the performance of the database and the usage of disk space. Logical order and page density issues exist on tables and indexes within databases. Tools for defragmentation at the level of the operating system cannot resolve these issues. The reason is that the fragmentation exists within the files, rather than at the file level itself. This solution brief describes fragmentation, the different types, how to defragment, how to compact data, and about interleaved indexes.

Presenter: IDERA
Share This:  Facebook Twitter LinkedIn
Try SQL Defrag Manager FREE for 14 days

Easily and Automatically Find and Fix SQL Server Index Fragmentation

  • Automate identification of index fragmentation "hot spots"
  • Schedule index defragmentation jobs
  • Avoid database contention with system resource pre-checks
  • Reduce page splits with index fill factor settings control
  • Centrally manage, report and notify instantly
Start for Free


Share This
Contact IDERA:
+1 (713) 523-4433