[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

sys.dm_db_index_usage_stats

Posted on 2012-09-11
2
Medium Priority
?
522 Views
Last Modified: 2012-09-12
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
Comment
Question by:cheryl9063
2 Comments
 
LVL 9

Accepted Solution

by:
Vijaya Reddy Pinnapa Reddy earned 2000 total points
ID: 38388775
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
 
LVL 9

Expert Comment

by:sarabhai
ID: 38390037
can you show the query?
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Loops Section Overview

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question