Blocking & Bottleneck rpts - don't have necessary data

Jan 23, 2009 at 3:15 PM
First off, thanks for the great tool! I'm loving the ReadTrace_Main report!

I collected an hour's worth of data using the "GeneralPerformance80" pssDiag "Instance-specific diagnostics" plus all of the Performance and Scans objects. Loaded this in but cannot see the Blocking and Bottleneck reports - both pop up w/ "database doesn't have necessary data".

Is there a specific template I need to use when collecting data or is there a newer .rdl I need? I noticed that sqlnexusCoreValidate.sql checks for tbl_Request/blocking_chains/notableActiveQueries none of which are in my sqlnexus db.

Thanks!
Coordinator
Feb 16, 2009 at 6:28 PM
you will need to follow instructions from http://www.codeplex.com/sqlnexus/Wiki/View.aspx?title=Sql2005PerfStatsScript&referringTitle=Home to collect data because the two reports you mentioned are collected by the scripts in the link