Andy Galbraith, one of our Senior SQL DBA’s, recently wrote a blog article “Embrace the Missing Index DMVs – But Proceed with Caution!”  In this article, Andy discusses the performance tool he uses all of the time: the set of Missing Index DMVs. The article is available at:

http://nebraskasql.blogspot.com/2017/03/embrace-missing-index-dmvs-but-proceed.html