Check Index Fragmentation on ALL Indexes in a Database

Here is a simple query that will list every index on every table in your database, ordered by the percentage of index fragmentation. This query will work on SQL2K5 or newer.

The output will look like

Source: myadventuresincoding.wordpress.com

Or

Please like or share this post if you found it helpful, thank you.
Share on Facebook
Facebook
0Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin
Email this to someone
email
Print this page
Print

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *