Is there a stored procedure to work out what indexes I should add?

Firstly, apologies if this is on the wrong site.

Secondly, I vaguely remember from a couple of years ago, when trying to heavily index a SQL Server 2005 db that there was a stored procedure that I could run that would 开发者_Go百科output stats on tables that would help judge where indexes should be placed.

Am I right in this, or was I dreaming it?

SQL Server 2005 and above have a missing indexes DMV.

Youll be wanting to look at the Performance Dashboard.

http://blogs.msdn.com/b/sqltips/archive/2007/03/29/sql-server-2005-performance-dashboard-reports.aspx