title: How do I monitor and find unused indexes in SQL database
body: <p>I would like to monitor index usage for an SQL database in order to find unused indexes and then drop them. How can I monitor index usage most efficiently? Which scripts could be useful?</p>
  <p>I'm aware of <a href="https://stackoverflow.com/questions/290773/identifying-unused-objects-in-microsoft-sql-server-2005">this question about identifying unused objects</a>, but this applies only to the current run of the SQL server. I would like to monitor index usage over a period of time.</p>