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

Index Usage Statistics Report not updated

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?

  • 2
1 Solution
anushahannaAuthor Commented:
jogos, that is talking about UPDATE Statistics. We are here discussing on 'Index Usage' report that comes with the database engine..
Raja Jegan RSQL Server DBA & ArchitectCommented:
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..
Raja Jegan RSQL Server DBA & ArchitectCommented:
Might be this query also can help you out with the statistics:

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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