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
LVL 6
anushahannaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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 & Architect, EE Solution GuideCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Might be this query also can help you out with the statistics:

http://www.mssqltips.com/tip.asp?tip=1239
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.