memory requirement

[mahendra]

:chat: I just came from V9 Database administration class.
I am new to Progress database world but I am not rooke in Database world. My background is in Oracle, Sybase and Microsoft SQL Server - all together 6 yrs.

My Question is -
1) How much memory required to support 2500 concurrent user on Sun solaris platform.
2) Is there any place from where I can download a trial version V9.1c database software and play with it until we officially buy the software.

Guru's your guides will be appreciated.

Thank you,
Mahendra Patel
MOORE Business Forms
Libertyville, IL

 

[MurrayH]

Quite a lot I'd imagine. Gus just pointed out the memory requirements (roughly) on www.peg.com. Here is a cut down re-print (-n == num users)

The exact formula is not published - it is fairly complicated and changes
from release to release.

For most purposes, you don't need an exact number. If you look in the R&D
section of promon, there is a display that will tell you how much shared
memory is allocated.

The major contributors are roughly

1. database buffers (-B times database block size)
2. database buffer headers (-B times 120)
3. lock table (-L times 34)
4. connection table (((-n+3) times 900) + (-Mn times 900))
5. transaction table (size of connection table * 50)

These are just rough numbers. To get the actual amount allocated, see
promon.


Hope that helps

Murray

 

[MurrayH]

Sorry .. almost forgot .. now download for V9.1C