Re: Slow reposnse

By apparently allowing all your users to gain a PDQPRIORITY of 8 you are limiting the number of concurrent queries to 11. Any that would take the sum of the PDQPRIORITIES above 100 will just sit there at the "gate" and show up in the Ready Queries list. Suggest you: - Set MAXPDQPRIORITY to some low value (say, 1) in onconfig AND / OR - Have individual users set their PDQPRIORITY to 0 unless they actually need to be using PDQ. Andy "Neil Truby" <neil.truby@ardenta.com> wrote in message news:<bve9ii$ral6g$1@ID-162943.news.uni-berlin.de>... > <timothy.a.brown@marconi.com> wrote in message > news:bve8i2$hap$1@terabinaries.xmission.com... > > > > > > please post 'onstat -g mgm' > > $ onstat -g mgm> > Informix Dynamic Server Version 7.31.FD5 -- On-Line -- Up 07:18:41 -- > 2993496 Kbytes > > Memory Grant Manager (MGM) > -------------------------- > > MAX_PDQPRIORITY: 40 > DS_MAX_QUERIES: 10 > DS_MAX_SCANS: 1048576 > DS_TOTAL_MEMORY: 92160 KB > > Queries: Active Ready Maximum > 10 11 10 > > Memory: Total Free Quantum > (KB) 92160 9216 9216 > > Scans: Total Free Quantum > 1048576 1048566 1 > > Load Control: (Memory) (Scans) (Priority) (Max Queries) (Reinit) > Gate 1 Gate 2 Gate 3 Gate 4 Gate 5 > (Queue Length) 0 0 0 11 0 > > Active Queries: > --------------- > Session Query Priority Thread Memory Scans Gate > 2127 c00000009ed80820 8 c00000009f79a770 0/0 1/1 - > 2403 c0000000a9199d88 8 1152/1152 1/1 - > 2378 c0000000a7a17d88 8 465/1152 0/1 - > 2380 c0000000a7c11d88 8 459/1152 0/1 - > 2412 c00000009ed0a5e0 8 460/1152 1/1 - > 2409 c00000009f0a05e0 8 466/1152 1/1 - > 2382 c0000000a7dd1d88 8 563/1152 1/1 - > 2384 c0000000a7f73d88 8 466/1152 1/1 - > 2386 c0000000a81025a0 8 460/1152 1/1 - > 2397 c0000000a05d5b68 8 586/1152 0/1 - > > Ready Queries: > -------------- > Session Query Priority Thread Memory Scans Gate > 2421 c00000009eee4410 8 c0000000a7a5e760 0/1152 0/1 4 > 2367 c00000009ecbf850 8 c0000000a8323818 0/1152 0/1 4 > 2377 c0000000a0e4b850 8 c0000000a33398b8 0/1152 0/1 4 > 2402 c0000000a0ef7850 8 c0000000a787bd40 0/1152 0/1 4 > 2400 c00000009f81d050 8 c0000000a7257e60 0/1152 0/1 4 > 2393 c0000000a8850f40 8 c0000000a7a5e4a0 0/1152 0/1 4 > 2401 c00000009ffd1ba0 8 c0000000a08e4450 0/1152 0/1 4 > 2396 c0000000a4a3f050 8 c0000000a21d15f0 0/1152 0/1 4 > 2394 c0000000a33416d0 8 c0000000a6a732f0 0/1152 0/1 4 > 2395 c00000009f3640d8 8 c0000000a06d5550 0/1152 0/1 4 > 2379 c0000000a0bb18a0 8 c0000000a5994da8 0/1152 0/1 4 > > Free Resource Average # Minimum # > -------------- --------------- --------- > Memory 8467.7 +- 1958.6 1152 > Scans 1048572.4 +- 0.0 1048559 > > Queries Average # Maximum # Total # > -------------- --------------- --------- ------- > Active 4.0 +- 2.3 10 90264 > Ready 20.8 +- 8.4 44 631 > > Resource/Lock Cycle Prevention count: 0