ERP Associates, Inc.

Thank you for your reply Brent.

-Yes it is possible to move our backups. But the thing is that my company works round the clock nights BPO people will work, so usage will be that much as in the morning.Anyways I will chk with my DBA.

-Only DB runs on the server.We have 4 CPU's and speed is 3GHz and it is Windows 2000 and processor is AMD.

-And regarding Process Scheduler I have already opened a case with Oracle.

Thanks for your support Brent, I will get back to you once Oracle tuning is done on our server.

This is a real informative post. Thanks alot Brent.

We are also facing the similar issue where in, the server configuration is 3GB RAM, 3PSAPPSERV's, Peopletools 8.43.18. The results of the recent load test told us that above 150 concurrent user's, the system is damn slow and almost not responding.

But, we are expecting 240 users to hit the system in the peak time.

We were planning to do the following steps.

1) Increase PSAPPSERV's from 3 to 6.
2) Increase thread count in weblogic console.
3) Run LOADCACHE program from frontend

Can you please help me in adding 3 PSAPPSERV's ? I never did that ?
Any more suggestions are appreciated for the performance improvement.

Thanks and regards,
Durga Prasad

1) Your box seems to be a bit short on memory. It's not uncommon for an 8.4x app server to eat up 2GB of RAM or more if it's sized large enough to handle the load you're describing. And if you have 3 of them plus a web server, forget about it! Have your SA monitor memory (free, pages in, pages out, and whatever else they deem useful) and convince yourself you don't have a memory problem before continuing.

2) Not sure why you'd want to configure 3 App Server Domains on a single box. Maybe I can see two so you can shut one down and keep the other one up. But it seems to me you'd be better served starting up additional APPSRV processes and increasing your Jolt Handlers, configuring Quick and Query Servers, etc.

3) To set up additional app server domains, just do it with PSADMIN, nothing special there. To make your web server use them, edit your configuration.properties file and find the line that says psserver=. Separate them w/ a comma. For example: psserver=SERVER1:9000,SERVER2:9010,SERVER3:9020

One thing to be very aware of: Make sure ALL of the servers in this string are valid, and ping-able from the web server. You don't want users sitting through TCP/IP timeouts until it finds a good app server to talk to.

4) Don't rule out the database until you've ruled it out. If the database is slow, it won't matter what you're doing on the front end.

I hope something in here helps.

By PSAPPSERV process, i meant the number that we get beside PSAPPSERV when we do the following.

1) Go to PSADMIN Utility.
2) Administer a domain.
3) Tuxedo command line
4) Type in PQ.

I was actually under the impression that, increasing number of PSAPPSERV processes will increase the number of concurrent user's that can log in to the system.

I am right here ?
If not, how do we actually do it ?
On what basis, system determines the maximum number of concurrent users ?


Thanks for your time and patience,
Durga Prasad

And just to add to the above information, i have one domain setup on the server.

And when i do PQ in the Tuxedo command line, the following is the result.

Prog Name Queue Name # Serve Wk Queued # Queued Ave. Len
--------- ----------- -------- --------- -------- --------
BBL.exe 64341 1 - 0 -
WSL.exe 00001.00020 1 - 0 -
JSL.exe 00095.00200 1 - 0 -
PSWATCHSRV.exe WATCH 1 - 0 -
JREPSVR.exe 00094.00250 1 - 0 -
PSAPPSRV.exe APPQ 6 - 0 -
PSBRKDSP.exe BRKDQ_dflt 1 - 0 -
PSPUBHND.exe PUBHQ_dflt 1 - 0 -
PSSUBHND.exe SUBHQ_dflt 1 - 0 -
PSPUBDSP.exe PUBDQ_dflt 1 - 0 -
PSQCKSRV.exe QCKQ 1 - 0 -
PSBRKHND.exe BRKHQ_dflt 1 - 0 -
PSSUBDSP.exe SUBDQ_dflt 1 - 0 -
PSSAMSRV.exe SAMQ 1 - 0 -

Pls Advice

OK I see what you're saying. Yep, looks like you need more APPSRV and QRYSRV processes started.

Edit psappsrv.cfg. Search for PSAPPSRV, and change the min/max processes. I'm not sure where you came up with 3, I'd probably start one for every 40 users to begin with as long as you have memory to do it, so that would be more like 6 for your expected load. Also start about 3 PSQRYSRV processes so your query users won't take up your available online slots by running long queries.

When you're done, go through PSADMIN and select Configure this domain. You don't have to edit any settings. Be ready to answer Y to the questions about configuring a PS Query Server. When you restart it, it will come up with the new # of PSAPPSRV & PSQRYSRV processes.

While you're in TMADMIN, keep an eye on your app server w/ the PSR command. It'll tell you which processes are busy. You always want to see one or two PSAPPSRV processes idle. PCLT will tell you how many users are waiting for requests, which is a good way to predict how much your phone will ring.