In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   Cloud ERP  |   Home  |   qad.com



  •     QAD Glossary

  • Example Sizing
    This section provides an example of how to size a BI system.
    Size a BI system with the following requirements:
    20 expected concurrent BI Portal users
    A 50-GB ERP source database
    Initially, three BI Modules required
    This example shows a single-tier deployment in which one server holds all BI components.
     
     
    Sizing Metric:
    Recommendation
    Note
    A
    CPU – DWD/Scheduler
    2 cores
     
    B
    CPU – Concurrent User Workload (Remote Portal Users)
    20 concurrent users = 6 cores
     
    C
    CPU – BI Portal Webapp
    1 core
     
    D
    CPU Total
    6 + 1 = 7 cores
    Max. (A,B) + C – This is a minimum requirement
    E
    RAM - DWD/Scheduler
    Assume “Medium” Load – 8+ GB
     
    F
    RAM – BI Portal Webapp
    2 GB
     
    G
    RAM – Concurrent User Workload (Remote Portal Users)
     
    H
    RAM - Total
    8+ + 2 + 4 GB = 14 GB
    As per RAM Sizing for DWD/Scheduler Component, the 4 GB extra is for the OS
    I
    Disk Sizing
    Carry out initial approximate sizing to create an approximate estimate of the initial DW size based on ERP table data. See “Reference: Estimation of Initial Database Size”.
    As a note, 500 GB is a recommended minimum but all new implementations should obtain disk sizing estimates using the referenced guidelines.
    J
    IO Subsystem
    15 k rpm SAS disks
    RAID 10 on a SAN/NAS device
    Minimum of 6 disks (12 disks if using mirroring).
    Again, depending on the estimated DW size, increase the number of disks in the RAID array.
    K
    Network Requirements
    ERP-to-BI Server: Minimum of 3 MBps (Mega-bytes per second) bandwidth
    Client-to-BI Portal: Minimum of 100 kbps (kilo-bytes per second) bandwidth per user
    Ensure 1-Gbps network card minimum on DW server. For two-tier deployment, also ensure at least a 1-Gbps network connection between the DW server and the BI Portal webapp server.