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 9:32 PM by jackli


jackli wrote Mar 7, 2008 at 1: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 http://www.codeplex.com/sqlnexus/Wiki/View.aspx?title=GETTING_STARTED&referringTitle=Home
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 8:24 PM

I downloaded the new release and this now works. Thanks