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/
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
