Post reply

sys.dm_dm_missing_index ...

  • February 15, 2012 at 11:28 am

    #251732

    I was poking around and found four sys.dm_db_missing_index columns;details;group_stats;groups DMVs. Looks like there is some good info here, however I google it but couldn't quite figure out how to use the info, and if the info is even worth using.

    This is all totally new to me - is this worth pursuing? Are there better ways to find missing indexes that would help performance? Any advice would be appreciated. Using SQL 2008 (not r2).

  • February 15, 2012 at 11:33 am

    #1447462

    It's a great place to start, but a terrible place to finish. Treat them as suggestions that need investigating, analysing and testing, not as a 'you must create these' list.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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