Index Fragmentation: Internals, Analysis, and Solutions

As soon as you have more than one index on a table, you're going to start seeing fragmentation. Many people know that this fragmentation is bad, but why is it bad? And what is the best way to get rid of it? Come find out from the person who wrote the tools for detecting and removing index fragmentation. In this session, you'll learn how fragmentation occurs and why the process that leads to it can often be as damaging to performance as the fragmentation itself. You'll also learn how to test for fragmentation, the different methods of removing it, and everything you need to consider when putting together an appropriate fragmentation-managemetn strategy.


About the Speaker

Paul is a Microsoft SQL Server MVP and a Microsoft Regional Director. He spent 9 years working on the SQL Server team, writing DBCC CheckDB, and ultimately responsible for the entire storage engine. In 2007 Paul left Microsoft to co-own and run SQLSkills.com, and is a world renowned author, consultant, and top-rated speaker on SQL Server performance tuning, administration, internals, and HA/DR. When he is not tweeting, blogging, or helping someone recover from a disaster, he's likely to be undersater somewhere in the world with his wife, Kimberly L. Tripp.

You can follow Paul digitally on Twitter (@PaulRandal) or via his Blogs


The Session slide deck and demo scripts are available here ...





Scroll to Top