SQLServerCentral / Administration / SQL Server 7,2000 / Some trace events have not been reported to SQL Server Profiler because the server has reached its maximum available memory for the process / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 03:00:53 GMT20RE: Some trace events have not been reported to SQL Server Profiler because the server has reached its maximum available memory for the processhttp://www.sqlservercentral.com/Forums/Topic600748-5-1.aspxCheck the index fragmentation and execution plan of query.MJThu, 13 Nov 2008 14:26:42 GMTMANU-J.RE: Some trace events have not been reported to SQL Server Profiler because the server has reached its maximum available memory for the processhttp://www.sqlservercentral.com/Forums/Topic600748-5-1.aspxManu, Transactions is a huge table and fld1 is indexed. Thanks.Thu, 13 Nov 2008 08:58:08 GMTramadesai108RE: Some trace events have not been reported to SQL Server Profiler because the server has reached its maximum available memory for the processhttp://www.sqlservercentral.com/Forums/Topic600748-5-1.aspxHow 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..MJWed, 12 Nov 2008 10:41:57 GMTMANU-J.Some trace events have not been reported to SQL Server Profiler because the server has reached its maximum available memory for the processhttp://www.sqlservercentral.com/Forums/Topic600748-5-1.aspxRunning trace on the following query shows :Some trace events have not been reported to SQL Server Profiler because the server has reached its maximum available memory for the processin the trace:select top 1 fld1,fld2,sum(Qty) from Transactions t INNER JOIN TempLocations t1 on t1.LocationNo=t.LocationNo where TypeID in ('R','Y') and updated = 0 and t.fld1 = '00979' group by t.fld1,t.fld2 having sum(Qty) > 0When I run the above query either thru application or thruquery analyzer, it keeps on running but does not produceany result. While the query is running, if I start the profiler, I get the above message.but if I remove the statement "and t.fld1 = '00979'then the query produces the result.This is strange. Can anyone help?Thanks.Tue, 11 Nov 2008 09:17:28 GMTramadesai108