Post reply

Find missing index in the whole instance

  • March 23, 2016 at 11:22 am

    #314233

    Comments posted to this topic are about the item Find missing index in the whole instance

  • March 28, 2016 at 6:57 am

    #1867948

    Thanks for the script.

  • March 28, 2016 at 11:32 am

    #1868035

    Why are people dissin' this with 3 stars? I like it and find it handy, thanks!

  • March 28, 2016 at 1:14 pm

    #1868053

    🙂

    tnx

  • March 29, 2016 at 10:49 pm

    #1868474

    hi, I'm getting this error while running the script: Msg 8152, Level 16, State 2, Line 23 String or binary data would be truncated.

    I enlarged the column Included_columns of the temptable #TempMissingIndex

    Thanks for the script.

    - leon

  • March 30, 2016 at 5:35 am

    #1868540

    I don't mean to be negative at all. This is a great script. However, what this doesn't tell you at all is what the improvement is, how much this will actually help the general system (meaning is this index going to help one query that runs 10 seconds once a week). I hope people don't see this and just blindly implement it all I am saying. This needs to be used in conjuction with running profiler and knowing your system.

  • March 30, 2016 at 5:51 am

    #1868549

    hi

    yes - this script just inform, if some db needs more exploration (if you have lots servers & lots db-s then it is helpful).

    i run this script periodically - once a week.

    blindly creating indexes is very bad 🙂

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply