Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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.

...

See https://dataself.atlassian.net/wiki/spaces/DS/pages/1603764297/ETL+Data+Warehouse#MS-SQL-Server-Configuration