Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How can I find most used columns in a table Expand / Collapse
Posted Monday, September 17, 2012 1:18 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 4, 2016 7:02 AM
Points: 587, Visits: 1,756

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,
Post #1360421
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse