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 – 10+ GB

 

F

RAM – BI Portal Webapp

2 GB

 

G

RAM – Concurrent User Workload (Remote Portal Users)

Not relevant (as per RAM Sizing for Concurrent Users (Interactive Portal Users))

 

H

RAM - Total

10+ + 2 + 4 GB = 16 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.