This might help. Add below line into ar.conf & restart ARS service. All data would be captured in thread logging. So enable Thread logs to track down the long running queries.
Large-Result-Logging-Threshold: 1048576 Your log file will look like something: <example> There are also some very large queries being run, the most significant example of which was against the form P08:RC_Check Entity-Segment Relationship. This retrieved over 6 million records and caused a memory jump of 400MB. <THRD> /* mar. oct. 20 2009 12:14:19.8190 */ Thread Id 60 (GLEWF) large result buffer allocation - /Length: 387606215/Entries: 6195560/Client Ver: >=10/RPC ID: 2069162/User: L0306749/Form: P08:RC_Check Entity-Segment Relationship _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
