Excerpt |
---|
For on-premises installations of DataSelf’s data warehouse. |
Specifications guidelines for the SQL Server database that hosts the data warehouse for ETL+.
...
Size: Varies. Usually a fraction of the source data base.
...
CPU threads: Minimum 4 to 8 .
...
RAM: preferably, the same size in GB as the data warehouse.
Minimum: I think that 16 to 32GB should be fine for now.
...
Disk: 200GB SSD preferably
...
Collation: The same as the source data base
...
Recovery model: Simple.
...
Compatibility level: Latest available.
...