SQL Tables/Fields Used the Most Frequently
Posted on 2015-02-23
I've run into a bit of an interesting issue. I was tasked with ID'ing which tables (or more so, fields) are being accessed the most frequently in our SQL Server 2008 database in order to determine the most commonly used fields. I'm able to get table row counts, but this doesn't tell me how long ago the table was accessed (could be old data). I've come across sys.dm_db_index_usage_stats, however I don't have permissions to run it.
So, my question: can anyone think of a way to solve this issue when your permissions aren't too high?
Thanks in advance for all your help!