How to check index usage ?

Question

How to check index usage ?

sql_butterfly

Ten Centuries

Points: 1264
More actions
February 2, 2011 at 5:26 am

#230938

Guys, how to check which index is being utilized and to what extent ? I tried analyzing dm_db_index_usage_stats but can't interpret it.

Viewing 4 posts - 1 through 3 (of 3 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

sys.dm_db_index_usage_stats is the DMV for that. What in there is confusing you?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

M&M SSC-Insane Points: 21700 More actions · Answer 2

Try this link.

http://www.sql-server-performance.com/articles/per/Obtaining_Index_Usage_Information_p1.aspx

M&M

sql_butterfly Ten Centuries Points: 1264 More actions · Answer 3

Gail, I just went through details and through some good articles. Was able to interpret informaiton now.

Thanks Mohammmed for the link. It's real good.