TSQL To Find Fragmented Indexes

Prior to the Database Health Reports with the Fragmented Indexes Report, I used the following query to track down fragmented indexes.

SELECT ps.avg_fragmentation_in_percent, name
  FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS ps
 INNER JOIN sys.indexes AS idxs 
    ON ps.OBJECT_ID = idxs.OBJECT_ID 
   AND ps.index_id = idxs.index_id

But now it is so much easier with the Database Health Reports with the Fragmented Indexes Report.

Enroll Today!

---

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

Download this page in PDF format