• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • 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?

thanks
0
anushahanna
Asked:
anushahanna
  • 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..
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Query listed in this site should give you the correct statistics..

http://decipherinfosys.wordpress.com/2007/03/06/index-usage-stats-in-sql-server-2005/

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:

http://www.databasejournal.com/features/mssql/article.php/3743596/SQL-Server-Management-Studio-Reports-and-Dashboard.htm

Hope the query in first link gives you the statistics correctly..
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Might be this query also can help you out with the statistics:

http://www.mssqltips.com/tip.asp?tip=1239
0

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