This project is read-only.


Blocking and Wait Statistics


When I try to run the report for Blocking and Wait Statistics I get the following message:
"The database doesn't have necessary data to run this report"
When I look in the out files there is blocking detected and data for the blocks. Why does the blocking report not work?

file attachments

Closed Aug 15, 2008 at 10:32 PM by jackli


jackli wrote Mar 7, 2008 at 2:41 PM

first, make sure the collection is for 2005. we don't have reports for sql server 2000.
ensure your data collection method used the instruction
you should have an output file like *__SQL_2005_Perf_Stats_Startup.OUT
otherwise, this report won't run

ShamanSC wrote Mar 13, 2008 at 9:24 PM

I downloaded the new release and this now works. Thanks

wrote Aug 15, 2008 at 10:32 PM

wrote Feb 22, 2013 at 12:49 AM

wrote May 16, 2013 at 12:18 PM