Index Usage Statistics Report not updated

Posted on 2009-12-23
Last Modified: 2012-05-08
Even though the database has been busy today, and I can see that there have been several user seeks on indexes, they are not seen in the report under 'Index Usage Statistics'.

The report under
SSMS->Right Click on DB->Reports->Custom Reports->Index Usage Statistics
gives me only 5 indexs as used but they all have been having 0 usage (seek,scan,updates).

Is there any settings/filters that can be altered, programmed for these reports?

Question by:anushahanna
    LVL 25

    Expert Comment

    LVL 6

    Author Comment

    jogos, that is talking about UPDATE Statistics. We are here discussing on 'Index Usage' report that comes with the database engine..
    LVL 57

    Accepted Solution

    Query listed in this site should give you the correct statistics..

    Built in Index Usage Statistics report employ some queries to display it in the reports and you can view the query used for that report using Profiler is givne below:

    Hope the query in first link gives you the statistics correctly..
    LVL 57

    Expert Comment

    by:Raja Jegan R
    Might be this query also can help you out with the statistics:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    794 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

    16 Experts available now in Live!

    Get 1:1 Help Now