Viewing Fragmented Indexes

SteveWWHA

Hi All

I am trialing SQL Monitor at the moment and putting something together to demo it to my boss as to why we need the tool. One thing i thought i saw while 'playing' with the tool was a list of indexes and the fragmentation of that index on a specific database.

Did i imagine this or is it possible to view these? If so, could someone point me in the right direction as to where to see these?

Thanks

Jessica R

Hi @SteveWWHA!

There is a Fragmented Index alert which is raised when:

• Fragmentation of one or more indexes in a database exceeds a percentage threshold.
• The fragmented indexes contain more than a specified number of pages.

You can see more on the alert here: https://documentation.red-gate.com/sm9/alerts/list-of-alerts

And you can find an example of the Fragmented Index alert here: https://monitor.red-gate.com/Alerts/SQLMON-EC2-BM2/Details/5111812?asOfTicks=637039431206266000&context=true

Is that what you had seen previously?

SteveWWHA

Hi Jessica

Thanks for the info and the alert is exactly what i have in place
What i was looking for was something which would tell me which indexes are fragmented and the % of fragmentation as well if possible

Thanks