Solution to a Read80Trace failure

microsoft.public.sqlserver.tools

21 Apr 2006 12:32 AM

donald.ferguson

I was having a problem with the Read80Trace tool which is available
through http://support.microsoft.com/Default.aspx?kbid=887057. The
error I was receiving was OSTRESS returned an error code of
-1073741819.

A profiler trace revieled that the last statement performed by OSTRESS
before the failure was "select dbid, name from master.dbo.sysdatabases
order by dbid". Through trial and error I was able to determine that
if there are more than 64 databases (including the PerfAnalysis
database created by the Read80Trace tool) on the SQL Server used to
process the trace data, then the failure occurs. If the server has no
more than 64 databases, Read80Trace works.

I hope someone finds this information useful.