OpenROAD Server Sizing

[Rowell Magno]

Hi,

Is there a specific computation or method to properly size a server for OpenROAD?

Would it be based on number of active users?

[Paul White]

HI Rowell,

Allow for basic normal server requirements (Win 2022 = 8GB RAM etc...)
If it is a terminal or citrix server, allow sufficient RAM for hungry desktop apps (browers, email, office).
Allow sufficient disk space for local and roaming user profiles.
If you are planning to run DBMS on the same server (bad idea) make sure you pay attention to DBMS architecture requirements.

RAM
Runtime 100MB-200MB RAM per OpenROAD process
Development double RAM allow for dev tools.
AppServer - depends if you are running dedicated slaves, similar requirements to runtime
If desktop users allow at least 1GB RAM per user

Disk space
OpenROAD Application Image = 100MB, then allow 1GB for various resources
Ingres client + OpenROAD runtime + OpenROAD Dev = 150MB

CPU
Depends on the application and other applications. OpenROAD only?  Start with 4 cores = 40 users.
If the server is also being used for desktop apps, I recommend 4 cores for 10 users.

Here are some print screens from a Citrix server farm member.
It is under stress with 45 users because the load balancing was not working properly.
Normally it comfortably supports 25 or so users.
Each user is running full desktop type applications.
Chrome uses the most RAM,  Sophos is the biggest disk I/O
--

ctxserver  32GB RAM 4 CPUs 150GB disk.
45 connected users  47GB RAM used by processes

Extract from SystemInfo
Total Physical Memory:     32,767 MB
Available Physical Memory: 1,787 MB
Virtual Memory: Max Size:  56,223 MB
Virtual Memory: Available: 11,397 MB
Virtual Memory: In Use:    44,826 MB


Resource Monitor


Tasklist excerpt


Analysis of running tasks


Disk I/O - OpenROAD doesnt appear in the top 100 processes



DiskSize
IngresII directory has OpenROAD runtime installation
Ingres directory has application resources, log files,  images etc.
Users have roaming profiles and local stores of Outlook profiles.





--

Paul White
&

[Rowell Magno]

Hi Paul,

Thank you for your response, the DBMS is running on a separate server and the App Server will exclusively be used for OpenROAD App Server running on a Windows Server OS.

You mentioned to start at 4 cores for 40 users. What if the load is 3000 users simultaneously connected and running OpenROAD only applications?

Would it have a different computation for CPU?

regards,

Rowell

[Paul White]

Hi Rowell,

I only have development lab experience with AppServer. Hopefully someone
on the chat can give some real world feedback.

My sizing is based on running w4glrun.exe processes, but the
calculations will be similar for ASO slaves.
RAM use is going to depend on the how the app is written:  Cached data
structures at the global level versus what is stored in session level.
CPU use will depend on how long requests take to complete, how many
slaves you are running and impatient users generating repeat requests.

Say you run several pools totalling 40 slaves configured for 100
connections each, 4000 connections in total, I would configure 4 cores
with 40GB RAM and allow extra 4-8GB for O/S
If you reduce the number of slaves, increase the connections per slave,
then you will reduce overall RAM but increase average response time.
Ideally, load balance across three or four servers for redundancy.


Paul
&

[Rowell Magno]

Thank you so much Paul. This will help on sizing the server we'll be needing.

Regards,

Rowell

[Adrian Williamson]

Hi Rowell,

 

What do Actian Pre-sales say?

 

I would have thought that they should provide this information for you or at least a formula to work with.

 

It is their product they are selling after all – I would be nervous about reverse engineering a server specification from good practice for a product I had to pay for.

 

Cheers

 

Adrian

--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/6177bdd7-1599-4441-a214-db73312928afn%40googlegroups.com.