Tools such as Activity Monitor, Profiler, the sys.dm_db_index usage_stats dynamic management view, and the sys.dm_db_missing_index_XXX family of dynamic management views provide information about popular queries, long running queries, popular indexes, unused indexes, and indexes that should exist but do not.