• Hi,

    you can't miss with Ola's solution regarding maintenance.

    If you want to analyze your indexes, have a look at sp_blitzindex[/url].

    It will tell you what is going on in your database, superb tool that has helped me a lot.