Missing Indexes in SQL Server 2005

  • ianstirk

    Ten Centuries

    Points: 1310

    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

  • denis.hosdil

    SSC Veteran

    Points: 253

    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 47 (of 47 total)

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