Is there any way I can tell which indexes in my databases are being used and how often? I want to see this to determine which indexes in my database are really being used vs. what the developers assumed would be needed. I am not looking for the answer that says: Use Query Analyzer and look at the execution plan to see which index is used for a particular query. I am looking for something that says: over the last month index 'a' was used 984326 times but index 'b' was used only 820 times. Does SQL server keep track of some counter which is incremented when a query uses a index? Maybe this is not done by default. Is there anyway I can turn this on and ask SQL server to keep track of this for a period of time after which I could turn this off.