Whitepaper : SQL Server Fragmentation Explained

As the data in the database tables of Microsoft SQL Server changes, their indexes change. Over time these indexes become fragmented so that ordered data retrieval becomes less efficient. Consequently, the fragmentation adversely affects the performance of SQL Server.

There are several types of fragmentation that can occur and impact SQL Server performance and space usage. Also, logical order and page density issues exist on tables and indexes within the database. These issues cannot be resolved by defragmentation tools at the level of the operating system because the fragmentation exists within the files, rather than at the level of the files themselves.

This whitepaper provides information to help understand the detailed mechanics behind fragmentation. It will also help to understand the methods and approaches for performing defragmentation to improve the performance of SQL Server. It will help understand SQL Server fragmentation and the performance benefits for SQL Servers by continuously monitoring and managing index fragmentation. It is intended for database administrators who want to truly understand the details and critical components of fragmentation in SQL Server.

The following is a summary of the key topics covered in the whitepaper:

* The difference between disk and SQL Server internal and external fragmentation
* How fragmentation affects performance
* The mechanics behind performance-robbing data voids
* The pros and cons of various approaches to managing fragmentation
* How SQL Defrag Manager provides a better, more efficient and automated approach to identifying and resolving index fragmentation in SQL Server
* How to judge the improvements gained by defragmenting servers

Topics :

Products :

Juan Rogers

Juan Rogers was the product manager and evangelist of the portfolio of security and compliance products of IDERA.

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