Jose, I would agree that you were waiting on a List thread. Have you run an arloganalyzer on a larger sample of the log to determine if you are thread bound?
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jose Manuel Huerta Guillén Sent: Monday, October 01, 2012 4:45 AM To: [email protected] Subject: Analizing a client log ** Hi listers, When opening a menu we see a big delay. The log retrieved at the client is: <CLAT> /* lun oct 01 2012 12:38:23.861 */+API call, Procedure #55 <API > <TID: 0000004740> <RPC ID: 0001075159> <Queue: List > <Client-RPC: 390620 > <USER: S013802 > /* lun oct 01 2012 12:38:59.8080 */+EXPQRY ARExpandQueryMenu from Mid-tier (protocol 14) at IP address XXXXXXXXXXXXXX <SQL > <TID: 0000004740> <RPC ID: 0001075159> <Queue: List > <Client-RPC: 390620 > <USER: S013802 > /* lun oct 01 2012 12:38:59.8080 */SELECT T856.C1,C1000000009,C1000000008 FROM T856 WHERE ((T856.C1000000007 = 'Resolution Method') AND (T856.C7 = 1)) ORDER BY C1000000007 ASC,C1000000012 ASC,C1000000008 ASC, 1 ASC <SQL > <TID: 0000004740> <RPC ID: 0001075159> <Queue: List > <Client-RPC: 390620 > <USER: S013802 > /* lun oct 01 2012 12:38:59.8080 */OK <API > <TID: 0000004740> <RPC ID: 0001075159> <Queue: List > <Client-RPC: 390620 > <USER: S013802 > /* lun oct 01 2012 12:38:59.8080 */-EXPQRY OK <CLAT> /* lun oct 01 2012 12:39:00.109 */-API call, Procedure #55 What I see looking at the log is that the API call is made at 12:38:29 but the API started to process at 12:38:59, that is 30 seconds later. My deduction from this log is that the API call was waiting to the thread to be available. Since the CPU usage currently is normally beyond 10% and the database engine can still accept more consumption, that means that I must increase the number of LIST threads. Is this correct or am I wrong? Thanks, Jose Manuel Huerta http://theremedyforit.com/ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
