Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Some trace events have not been reported to SQL Server Profiler because the server has reached its maximum available memory for the process Expand / Collapse
Author
Message
Posted Tuesday, November 11, 2008 9:17 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:52 PM
Points: 377, Visits: 685
Running 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 process

in 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) > 0

When I run the above query either thru application or thru
query analyzer, it keeps on running but does not produce
any 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.
Post #600748
Posted Wednesday, November 12, 2008 10:41 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, February 27, 2014 11:17 AM
Points: 1,688, Visits: 8,756
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
Post #601541
Posted Thursday, November 13, 2008 8:58 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:52 PM
Points: 377, Visits: 685
Manu,
Transactions is a huge table and fld1 is indexed.

Thanks.
Post #602198
Posted Thursday, November 13, 2008 2:26 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, February 27, 2014 11:17 AM
Points: 1,688, Visits: 8,756
Check the index fragmentation and execution plan of query.

MJ
Post #602403
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse