|
Recommendations were identified through tests performed on Azure Linux (Ubuntu 18.04 LTS) Fsv2 Virtual Machines. Premium SSDs were used for all database instances. Results may differ on other cloud providers, physical hardware, or operating system combinations.
|
Size
|
ThingWorx Foundation (each node)
|
Relational DB
(SQL Server or PostgreSQL)
|
Relational DB
(Azure PostgreSQL Flexible)
|
Time-Series DB Data Node(s)
(InfluxDB)
|
---|---|---|---|---|
X-Small H2*
(H2 in-memory DB)
|
4 vCPUs
8 GiB RAM
|
|||
Small H2*
(H2 in-memory DB)
|
8 vCPUs
16 GiB RAM
|
|||
Small(RDBMS Only)
|
8 vCPUs
16 GiB RAM
|
8 vCPUs
16 GiB RAM
|
16 vCPUs
64 GiB RAM
1 TB
|
|
Small +(with InfluxDB**)
|
8 vCPUs
16 GiB RAM
|
4 vCPUs
8 GiB RAM
|
4 vCPUs
8 GiB RAM
|
|
Medium(RDBMS Only)
|
16vCPUs
32 GiB RAM
|
16vCPUs
32 GiB RAM
|
16 vCPUs
64 GiB RAM
1 TB
|
|
Medium +(with InfluxDB**)
|
16vCPUs
32 GiB RAM
|
8 vCPUs
16 GiB RAM
|
8 vCPUs
16 GiB RAM
|
|
Large(RDBMS Only)
|
32vCPUs
64 GiB RAM
|
32vCPUs
64 GiB RAM
|
32 vCPUs
128 GiB RAM
2 TB
|
|
Large +(with InfluxDB**)
|
32vCPUs
64 GiB RAM
|
16 vCPUs
32 GiB RAM
|
16 vCPUs
32 GiB RAM
|
|
Large (HA) + Azure Flex HA
|
48 vCPUs
192 GiB RAM
8 TB
|
|||
Reminder: Sizing Guide recommendations are intended for use initial baselines to size ThingWorx implementations. Individual results will vary based on edge configuration, application load, etc.
|
||||
* The H2 in-memory database is not supported for production implementations.
** ThingWorx can use either the open-source, single node version of InfluxDB, or an InfluxDB Enterprise cluster for high availability and increased performance. The InfluxDB open-source version was used for these sizing tests. For InfluxDB Enterprise sizing, plan for two InfluxDB “Data” nodes as indicated, plus three “Meta” nodes, typically 1-2 vCPUs and 0.5-1GiB RAM each. For more guidance on InfluxDB sizing, please review https://docs.influxdata.com/influxdb/v1.8/guides/hardware_sizing/.
|
|
Azure PostgreSQL Flex Server needs more computing and storage than the on-prem database to achieve a similar Value Stream queue rate. Components like max IOPS and IOPS bandwidth depend on compute and storage size.
|