Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Monday, September 17, 2012 1:18 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 8:53 AM
Points: 411, Visits: 1,310
Hi,

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