Sean Lange (7/16/2013)
At best you can find out what indexes have been used. This is not the same as what tables. So often this type of request is followed up by an explanation that the intention is to delete "unused" tables. Tread lightly here. There are often processes that run only once a year and might fall on your "to be deleted" list.
I am guessing that you want to find some sort of date information with this? Take a look here.
select * from sys.dm_db_index_usage_stats
Hi, thanks for quick reply.
I am about to upgrade my crm system and it requires upgrading the database too.
The task is to select the tables that our users have used recently (during last 2 years for instance) and concentrate on them at first.
The database consists of over 300 tables.
Tell me please what i should understand by columns: last user seek, last user scan, last user lookup, last user update and system respectively in sys.dm_db_index_usage_stats table
Which one is the most important in my case?
Can I just order by last lookup etc. to obtain the desired effect ie. if the table has been used or not for the specified time?
Thank you very much in advance.