• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 528
  • Last Modified:

sys.dm_db_index_usage_stats

I have a table that is using a lot more memory than other tables. I ran a query using sys.dm_db_index_usage_stats. I'm new to this and wanted to see if I could get some help. The table has a PK index on it. Can you explain what I'm seeing? The results of my query show:

user_seeks
213873
user_scans
3553
user_lookups
30400
user_updates
230854
SizeMB
24649
0
cheryl9063
Asked:
cheryl9063
1 Solution
 
Vijaya Reddy Pinnapa ReddyCommented:
user_seeks – the number of times the index has been used in a user query in a seek operation (one specific row)

user_scans – the number of times the index has been used by scanning the leaf pages of the index for data

user_lookups – for clustered indexes only, this is the number of times the index has been used in a "bookmark lookup" to fetch the full row. This is because non-clustered indexes use the clustered indexes key as the pointer to the base row.

user_updates – The number of times the index has been modified due to a change in the table's data.


ALso refer the following msdn document,
http://msdn.microsoft.com/en-us/library/ms188755.aspx
0
 
sarabhaiCommented:
can you show the query?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now