Say I have a very big table from which a lot of reporting is done in daily basis.
It has defined like 9 indexes, for different columns, this occupies a lot of disk space and for some reason, I suspect some of these indexes are not even used, or needed.
I want to know or test whether in a period of two or three days, these indexes are used.
I know I have to start activating the profiler and..... that's where I need help.
Please, advise.
Oh, wait, I know I can take one individual query, run it in the SSMS and see the query plan, of course.
But I want to somehow automate the process of checking whether some indexes are or are not being used.
Actually, what I really want, is just return the list of indexes used by a certain amount of queries during a certain period of time. Then I'll make the comparison and discard the unused.
