February 15, 2012 at 11:28 am
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
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy