Nexus and SQL 2000 - can't run some reports

Sep 3, 2009 at 10:20 AM

Hi,

I'm using PSSDiag to monitor SQL 2000. I've selected to monitor SQLDiag, Blocking (Latch, FAST), Profiler (DetailedPerformance80 template) and Perfmon.

After data import I can see "SQL 2000 Perf" and "ReadTrace_Main" reports but not "Bottleneck Analysis" and "Blocking and Wait Statistics".

I'm receiving this error: "The Database doesn't have necessary data to run this report".

Any idea what is wrong?

Coordinator
Sep 5, 2009 at 2:07 AM

The "Blocking and Wait Statistics" and "Bottleneck Analysis" reports are dependant on the SQL 2005 Perf Stats script which is the "Big Brother" of the SQL 2000 Blocker script. This script will not work on a SQL Server 2000 instance as it uses DMVs. If you need a report for the SQL 2000 Blocking Script, install the Version 3.0 of Nexus which has SQL 2000 Blocking report available in it.