Posted on 2012-09-11
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:

Question by:cheryl9063
    LVL 9

    Accepted Solution

    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,
    LVL 9

    Expert Comment

    can you show the query?

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now