How to collect the Fragmentation and missing index in DBA dash

[kandavel88]

How to collect the Fragmentation and missing index in DBA dash.

[DavidWiseman]

DBA Dash doesn't collect data relating to fragmentation or missing indexes. For missing indexes, you can run sp_BlitzIndex from DBA Dash on demand from the community tools node in the tree (see link for how to configure). You could also execute your own proc from DBA Dash to pull missing index or fragmentation info. If you want to collect/store the information and report on it (rather than on demand), a custom collection and a custom report could be used.

Hope this helps,

David