Missing Indexes in SQL Server 2005

• ianstirk

  Ten Centuries

  Points: 1310

  More actions

  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

• denis.hosdil

  SSC Veteran

  Points: 253

  More actions

  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!