InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 02:55:28 GMT20http://www.sqlservercentral.com/Forums/Topic1360421-1550-1.aspxHi,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,Mon, 17 Sep 2012 13:18:35 GMTsql-lover