|
SQL Server Fragmentation Explained
As the data in Microsoft SQL Server tables changes, their indexes change. Over time, these indexes
become fragmented. This fragmentation will adversely affect performance. This technical white paper
provides information to help you understand the detailed mechanics behind fragmentation. It will also
help you understand the methods and approaches for performing defragmentation so you can improve
your SQL Server’s performance.
This technical white paper will help you understand SQL Server fragmentation and the performance
benefits you can gain on your SQL Servers by continuously monitoring and managing index
fragmentation. Key topics covered in this paper include:
- 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 easier approach to solving fragmentation problems in SQL Server.
- How to judge the improvements gained by defragmenting your server.
Please answer a few questions about yourself and your interests. This information
will help us to bring you the most relevant content and information. Fields marked
with an asterisk
 are
required.
| Contact
Information |
 |
| Additional
Information |
|
If you have any difficulty registering, please contact
support
for immediate assistance.
|