Thank you all for responses. Misi,
It is not altogether clear how you have come to the conclusion that list-calls are sent to the fast-queue. I have never seen this happen. - I was looking at these lines, List queue rpc 390620, eventhought 390620 is Fast. <API > <TID: 0000003876> <RPC ID: 0000000136> <Queue: List > <Client-RPC: 390620 You can always use environment variable ARRPC=390680, export ARRPC to force runmacro, or any API-program not overriding the setting, to connect to a specific queue. - I will try this for runmacro. ? - can it be done for webservices? Kirin, We are about to upgrade to 7.6 SP3 on test environment. thank you both, for the analysis. ---- Just learnt that the memory allocated to the db is less than 1gb. Its supposed to be 4 gb. So, after we make this change. Further analsys will be done. ---- Using 30 day trail for Carl's tool. This is what I got - loading sql, api, filter logs. (missed escalation). It seems that is no queuing and in terms of fast and list, the current allocation may be sufficient. --- ===================================== Log Start Time: 10/5/2012 7:39:43 AM Log End Time: 10/5/2012 7:39:43 AM Elapsed Time: ===================================== ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Queue Type Thread Count Min Thread Time Max Thread Time Average Thread Time Total Active Time ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Admin 0000000772 10746 0.0000 32.595 0.0384 413.44 AppLicAudt 0000005675 32 0.0001 0.0599 0.0070 0.2267 Escala 0000001306 84 0.0000 0.8363 0.0282 2.3764 Escalation 0000001306 438 0.0000 50.330 0.1469 64.364 Fast 0000001820 3005 0.0000 02.669 0.0231 69.652 Fast 0000002077 3971 0.0000 19.299 0.0321 127.48 Fast 0000002334 3542 0.0000 11.731 0.0297 105.50 Fast 0000002591 2511 0.0000 18.987 0.0319 80.215 Fast 0000002848 3083 0.0000 02.585 0.0348 107.32 Fast 0000003105 3340 0.0000 34.848 0.0720 240.58 Fast 0000007731 2822 0.0000 14.884 0.0372 105.19 Fast 0000008245 2024 0.0000 02.900 0.0268 54.433 Fast 0000009273 2486 0.0000 18.839 0.0287 71.458 Fast 0000009530 2639 0.0000 02.997 0.0220 58.251 Fast 0000009787 4085 0.0000 02.568 0.0315 128.88 Fast 0000010044 2249 0.0000 02.678 0.0193 43.452 List 0000003362 1345 0.0000 16.310 0.0438 59.027 List 0000003619 1352 0.0000 40.832 0.0584 78.961 List 0000003876 1326 0.0000 02.710 0.0283 37.569 List 0000004133 1327 0.0000 01.851 0.0271 36.042 List 0000004390 1330 0.0000 15.843 0.0425 56.568 List 0000004647 1336 0.0000 04.363 0.0286 38.277 List 0000008502 1358 0.0000 02.289 0.0262 35.581 List 0000008759 1283 0.0000 01.752 0.0257 33.099 List 0000009016 1393 0.0000 01.984 0.0271 37.851 List 0000010301 1306 0.0000 35.774 0.1821 237.84 List 0000010558 1412 0.0000 02.368 0.0292 41.250 List 0000010815 1316 0.0000 02.628 0.0252 33.233 Prv:390680 0000004904 558 0.0000 01.547 0.0260 14.551 Prv:390680 0000007988 526 0.0000 02.476 0.0430 22.640 ServStats 0000006446 10 0.0000 0.0269 0.0075 0.0757 Total Transaction Count: 150416 Total API Transaction Count: 137009 Total SQL Transaction Count: 13407 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Queue Type Total Number of Threads % of Threads with No Idle Gap (100% '0' Idle Time) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Admin 1 (0) 0% Escalation 1 (0) 0% Fast 12 (0) 0% List 12 (0) 0% Private 2 (0) 0% ServerStat 1 (0) 0% _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<image.PNG>>
