Visualizing Index Fragmenation

We all probably realize that fragmentation can be a performance hindrance, especially for scanning operations.  But, what does fragmentation really mean?  What does it look like?  I’ve been doing a lot of training for customers lately in terms of fragmentation so I wanted to do a blog post and dig a bit further into what…

2

Index Rebuild vs Reorganize: The transaction log edition

Recently a friend and fellow PFE Dave Levy (Twitter/Blog) and I were discussing a question someone posted in a forum. The question was in regards to database mirroring latency when a reorganization occurs. Dave mentioned that he has seen in the past that switching from performing a reorganization to a rebuild resulted in better throughput…

8