Post reply

Missing Indexes in SQL Server 2005

  • July 26, 2010 at 12:47 am

    #1198025

    Hi,

    Nice article.

    You can discover a lot more about DMVs in this forthcoming book www.manning.com/stirk. Chapter 1 can be downloaded for free and includes scripts for:

    A simple monitor

    Finding your slowest queries

    Find your missing indexes

    Identifying what SQL is running now

    Quickly find a cached plan

    Thanks

    Ian

  • July 30, 2010 at 1:13 pm

    #1200518

    I have found this feature very helpful but could be improved, I would even call it buggy:

    - As Microsoft mentions, it does not consider trivial Plans. Why not? A trivial index from a trivial query on a huge table is missing - I'd like to know about it!

    - Actually recomended a few indexes that already existed!

Viewing 2 posts - 46 through 46 (of 46 total)

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