September 17, 2012 at 1:18 pm
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,
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy