RSA Scripts

List of fregmentation objects

List of fregmentation objects on the current database. The last column will show in percents the fregmentation.

  1. Sql Server
  2. Performance
  3. Intermediate
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

SELECT db_name(ps.database_id) AS'Database Name',
       object_name(ps.OBJECT_ID) AS'Database Object',
       ps.index_id, b.name, ps.avg_fragmentation_in_percent
  FROM sys.dm_db_index_physical_stats(DB_ID(),NULL,NULL,NULL,NULL) AS ps
       INNER JOIN sys.indexes AS b 
    ON ps.OBJECT_ID=b.OBJECT_ID
   AND ps.index_id=b.index_id
 WHERE ps.database_id=DB_ID()
 ORDER BY ps.avg_fragmentation_in_percent DESC
GO