I do have a DMV that lets me see how my Clustered Index is being used (per table) and I do have another one, that let me see how many time my table has been accessed. But I can't find a way to identify specific columns on those tables, how many times are being used and if its for updates, seeks, scans, etc.
Is there any way to do it?
More background: I do have several big tables and databases which I would like to improve in terms performance and design. I already identified few slow queries on it, but wanted to validate if old Indexes are actually satisfying the existing queries when they touch certain columns.
Hopefully I explained myself properly.
Thanks in advance,