Home Forums SQL Server 7,2000 Administration Some trace events have not been reported to SQL Server Profiler because the server has reached its maximum available memory for the process RE: Some trace events have not been reported to SQL Server Profiler because the server has reached its maximum available memory for the process

  • November 12, 2008 at 10:41 am

    #897655

    How many rows are there in transactions table? If its a big table then try indexing this field fld1 which u said is slowing down the query and see if this helps..

    MJ