R
Ruanne Cluer
Guest
I assume this is 10.2B - I see that you're allocating more than the 2GB limit for 32-bit OS (400000 * 8) and the shared memory segment size is 128MB, which would imply that you're using 32-bit OpenEdge? The /3GB, /PAE and /AWE switches needed to accomplish this have never been a good idea. Then again, with a 13 GB database and 50 users, you should probably look at using the 64-bit version. You could consider; Raising the Max Servers and Number of Servers ( 5 > 10) Lowering the Maximum clients per server ( 10 > 5) Increasing your bibufs Are the 13 GB all part of the working datasets, or is it time to archive data out? When last was this database dumped and loaded or at least integrity checked and indexes rebuilt? Are you using Type II Storage Areas - you should be. Are there still application tables/indexes in the Schema Area - there really should no longer be. screens that freeze or clients disconnecting their in-process sessions would need more explicit investigation, starting with the application code that they're running at the time and what trouble they're getting into when doing so. Ideally reproducible scenarios can make use of clientlogging to get a better picture
Continue reading...
Continue reading...