find Last used date of an index

Question

find Last used date of an index

ravisamigo

SSCertifiable

Points: 7440
More actions
September 14, 2011 at 2:06 am

#104092

hi,
How to find Last used date of an index in SQLServer 2005?
Please advice.
Thanks and Regards,
Ravi.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

rama38udaya Ten Centuries Points: 1272 More actions · Answer 1

Hi Ravi,

It is bit difficult (how ever if you have set up some triggers when ever the index is used),how ever we can use DMV to get some useful information -Last user -seek,scan,lookup,update via -sys.dm_db_index_usage_stats.

Check the link :http://blogs.msdn.com/b/sqlcat/archive/2006/02/13/531339.aspx.

Best Regards,

Rama Udaya.K