Workbench Resource Requirements

anafziger

Hi Everyone,

 

2 questions about Workbench:

1. Is running a job in workbench (specifically one pulling from an FTP connection) more CPU or Memory intensive?
2. Can you run multiple instances of workbench all under the same user credentials at the same time?

We are planning on running workbench on EC2 instances in auto scaling groups based on how many jobs we have to run.  There are EC2 instances optimized for compute power as well as those optimized for RAM - we are trying to determine which would best suit running workbench jobs.  

 

This will be easy to test once we scale fully but we'd like to architect for scale as opposed to using the age old "wait and see" method.

 

Thanks!

anafziger

A Domo engineer was able to help me out with this one and the answer is:

 

I would say that it depends on the job.  A job with many rows / columns is more memory intensive than a job with a small amount of rows / columns.   The same is true with CPU usage.  CPU is also impacted by the number of jobs running simultaneously. As far as memory resources are concerned, Windows will use disk space as memory if additional memory is needed (using disk space will slow down the job performance and increase the CPU utilization because disk I/O is slow compared to RAM I/O.)  The reality is that modern computers are fast enough that the disk I/O time is negligible.

 

Hope this helps anyone who finds themselves asking the same question.

kshah008

Hi all,

 

Can anybody help @anafziger out?

Thanks!

anafziger

A Domo engineer was able to help me out with this one and the answer is:

 

I would say that it depends on the job.  A job with many rows / columns is more memory intensive than a job with a small amount of rows / columns.   The same is true with CPU usage.  CPU is also impacted by the number of jobs running simultaneously. As far as memory resources are concerned, Windows will use disk space as memory if additional memory is needed (using disk space will slow down the job performance and increase the CPU utilization because disk I/O is slow compared to RAM I/O.)  The reality is that modern computers are fast enough that the disk I/O time is negligible.

 

Hope this helps anyone who finds themselves asking the same question.