This project is read-only.

database doesn't have necessary data

Oct 6, 2009 at 8:27 PM


I downloaded the most recent SQL Nexus Tool to review traces created on a SQL 2000 box using the most recent PSSDiag.

The data seems to import ok, but on every report I get "The Database doesn't have necessary data to run this report.

Do I need to download a different version to read traces created on SQL 2000?  If so where do I get this version?

Oct 10, 2009 at 4:04 PM

Which report are you try to view? Profiler Traces can be read using the Read Trace report. If you have imported SQL 2000 PSSDIAG data, then use the SQL 2000 Perf Stats reports to view the blocking information. Read trace can be used for SQL 2000 Profiler Traces as well. However, SQL 2005 Perf Stats reports cannot be used for analyzing SQL Server 2000 PSSDIAG data.