index fragmenation

Get Index Fragmentation Percentage for all Tables in SQL Server Database

Submitted by Ben Hodson on Sun, 10/19/2008 - 15:17

Here is a useful script I've been able to put together from multiple posts online that gets the estimated index fragmentation for all tables in your database where the fragmentation percentage is greater than the where clause. Here's the SQL:

select object_name(itable.object_id) as tablename,
itable.name as IndexName,
indexfrag.avg_fragmentation_in_percent