Add the following line to your ar.conf/cfg Large-Result-Logging-Threshold: 4000000
Turn on thread logging. You will see the large queries in the thread log. Adjust the 4000000 so that you get those large queries you want... <THRD> /* Mon Oct 11 2010 10:07:49.5500 */ Thread Id 5544 (GLEWF) large result buffer allocation - /Length: 5320505/Entries: 11776/Client Ver: >=10/RPC ID: 1716385/User: xxx/Form: PCT:Product Catalog/ <THRD> /* Mon Oct 11 2010 10:12:07.3380 */ Thread Id 5468 (GLEWF) large result buffer allocation - /Length: 5320505/Entries: 11776/Client Ver: >=10/RPC ID: 1722110/User: xxx/Form: PCT:Product Catalog/ <THRD> /* Mon Oct 11 2010 12:17:46.0570 */ Thread Id 5476 (GLEWF) large result buffer allocation - /Length: 13243952/Entries: 35478/Client Ver: >=10/RPC ID: 1899065/User: xxx/Form: HPD:Help Desk/ <THRD> /* Mon Oct 11 2010 14:06:44.9230 */ Thread Id 5480 (GLEWF) large result buffer allocation - /Length: 5320505/Entries: 11776/Client Ver: >=10/RPC ID: 2054987/User: xxx/Form: PCT:Product Catalog/ <THRD> /* Mon Oct 11 2010 14:09:28.7150 */ Thread Id 5528 (GLEWF) large result buffer allocation - /Length: 4919872/Entries: 10892/Client Ver: >=10/RPC ID: 2059279/User: xxx/Form: PCT:Product Catalog/ <THRD> /* Mon Oct 11 2010 14:37:00.6220 */ Thread Id 5508 (GLEWF) large result buffer allocation - /Length: 5203802/Entries: 11513/Client Ver: >=10/RPC ID: 2101801/User: xxx/Form: PCT:Product Catalog/ <THRD> /* Tue Oct 12 2010 13:52:47.0810 */ Thread Id 5516 (GLEWF) large result buffer allocation - /Length: 4835109/Entries: 14968/Client Ver: >=10/RPC ID: 3628609/User: xxx/Form: HPD:Help Desk/ Tony Worthington | Sr. Technical Analyst | Kohl’s Department Stores N56 W17000 Ridgewood Drive | Menomonee Falls, WI 53051 | office: (262) 703-7763 | e-mail: [email protected] From: "Frank, Gordon M. (CMS/CTR)" <[email protected]> To: [email protected] Date: 10/12/2010 10:17 AM Subject: Re: Simulating the UNIX PS command on Windows Sent by: "Action Request System discussion list(ARSList)" <[email protected]> ** Thank you! That’s just what I needed Gordon From: Action Request System discussion list(ARSList) [ mailto:[email protected]] On Behalf Of Darrell Reading Sent: Tuesday, October 12, 2010 9:35 AM To: [email protected] Subject: Re: Simulating the UNIX PS command on Windows ** Click this link and go to the second URL: http://www.google.com/search?source=ig&hl=en&rlz=1G1GGLQ_ENUS329&q=ps+-ef+windows&aq=f&aqi=&aql=&oq=&gs_rfai= Darrell Reading Systems Engineer Phone 479.204.5739 [email protected] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better From: Action Request System discussion list(ARSList) [ mailto:[email protected]] On Behalf Of Frank, Gordon M. (CMS/CTR) Sent: Tuesday, October 12, 2010 08:26 To: [email protected] Subject: Simulating the UNIX PS command on Windows ** Is there a way to simulate the UNIX PS command on a Windows Server environment? I have an unqualified search which shows up on my server occasionally and I’d like to try to find out who it is. Any other ideas are welcome. Thanks _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. *** Walmart Confidential *** _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ********************************************************************** CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time without any further consent.
