Index Usage Stats Report

[ptheriault]

Has anyone used the Index Usage Statistics report in SQL Mangement Studio? I have tried to run the report but it doesn't show any data?

 

[Catadmin]

How do you get to this report? Maybe I'm blind, but I'm not seeing it in the initial menus.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[ptheriault]

From Management Studio, hightlight the DB name, then on the right select the drop down arrow next to report. The 3rd from the bottom should be index usage stats. Does it work for you?

 

[Catadmin]

Oddly enough, I see the title, the server name, the time & date and then a description of what the report does, but that appears to be it.

What Build are you running? RTM? SP1? SP1 with hot fixes?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[ptheriault]

I'm running build 9.0.2047

 

[ptheriault]

I get the same results as you. I was expecting a report that might show me how often each index is used.