SQL Server, Heaps and Fragmentation

SQL Server Fragmentation Impact with Modern Hardware

Read this article to find out if you still need to worry about SQL Server index fragmentation with modern hardware.

[Video] Fragmentation Explained in 20 Minutes at SQLBits

What does fragmentation mean? How does it happen? Can you fix it with fill factor? Should you rebuild your indexes to fix it?

Index fragmentation on all databases

The script returns all the fragmented indexes on all databases on the instance you run it. Can be run on multiple instances in the same time using central management capability.

Defrag All Indexes On a Database

Script to list out all fragmented indexes for a given database, with options to only view them, reorganize them, or rebuild them in one fell swoop.

The Real World: Fragmented Disk and High PAGEIOLATCH Waits

This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.

No Significant Fragmentation? Look Closer…

If you are relying on using 'best-practice' percentage-based thresholds when you are creating an index maintenance plan for a SQL Server that checks the fragmentation in your pages, you may miss occasional 'edge' conditions on larger tables that will cause severe degradation in performance. It is worth being aware of patterns of data access in particular tables when judging the best threshold figure to use.

Analyze and Fix Index Fragmentation in SQL Server 2008

This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation

2008 Index Fragmentation Maintenance

Just a stab at automating index maintainenance in SQL Server 2008

Are disk volumes fragmented on server? Does it require to be defragged

Disk Fragmentation is one of the cause of degraded performance. Use this script for fragmentation analysis report.