How to find out which MS Sql Indexes are fragmented
/* Find index fragmentation */
SELECT 
 DB_NAME(DATABASE_ID) AS [DatabaseName],
 OBJECT_NAME(OBJECT_ID) AS TableName,
 SI.NAME AS IndexName,
 INDEX_TYPE_DESC AS IndexType,
 AVG_FRAGMENTATION_IN_PERCENT AS AvgPageFragmentation,
 PAGE_COUNT AS PageCounts
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, N'LIMITED') DPS
INNER JOIN sysindexes SI 
ON DPS.OBJECT_ID = SI.ID AND DPS.INDEX_ID = SI.INDID
order by AvgPageFragmentation desc
GOWritten by Pure Krome
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
 #Sql 
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#

 
 
 
 
