title: sys.dm_db_missing_index_details returns no rows
body: <p>I have tried to look at sys.dm_db_missing_index_details to check for missing indexes on my SQL Server 2005 database. It is returning no rows.</p>
  
  <p>It is possible that it should be empty but highly unlikely as I have not added ANY indices on any table (except the ones you get by creating primary keys). I am also running unit tests as well as adhoc development tests (using Linq to SQL) against it so there is some activity against it.</p>
  
  <p>Do I need to turn on the capturing of this data?</p>
  
  <p>Is this only supported on certain editions of SQL Server 2005?</p>
  
  <p>Thanks in advance for any efforts to help.</p>