This applies to : Visual Data Discovery To maximize the operational efficiency of Symphony., you need to take into account several factors to appropriately size the Symphony. server in your operating environment:
  • Concurrent user count. This is the most important parameter that increases the load on the system. Concurrent users represent only a portion of the total number of available users in an organization who may access the Symphony. server at the same time. A single-node deployment can handle up to 100 concurrent users with acceptable performance. If you need more than 100 users, you should consider using several Symphony. nodes.
  • Entity (users, data sources, visuals, dashboard, etc) count. The number of entities in the system doesn’t impact the performance of the system if you have up to 1000 instances of each entity type. If you want to support more than 1000 instances of each entity type you must allocate more resources than shown in the table below.
  • Data cardinality. The amount of data processed doesn’t affect the performance of Symphony., because Symphony. pushes the work for the queries down to your data stores and thus will rely on the performance of your data stores. However, if you have large data set and want to group the data by a high-cardinality field, you should increase the resource allocation for the query engine.
  • High availability (HA). If your Symphony. environment is an HA environment, sizing requirements may double if each Symphony. microservice is running on multiple instances.
The table below reviews the recommended sizing guidelines for a single-node Symphony. server. Keep in mind that the specifications provided are suggested starting points and reflect only the minimum estimates. Sizing for performance is impacted by many other factors outside of the ones mentioned here, such as where Symphony. resides, the types of data sources you are using, interactions between applications and data sources, and a variety of other factors. The following sizing guidelines reflect testing of a single-node Symphony. server with up to 1000 concurrent users, 400 data sources, 500 dashboards, and 6000 visuals.
Concurrent UsersHardware RequirementsTime Opening Dashboard (12 Visuals)Composer WebQuery EngineConnectorPostgreSQL Metadata Store
Up to 5Memory: 8 GB
CPU: 8 core
Disk: 100 GB		17 secondsMemory: 2 GBMemory: 1 GBMemory: 512 MBMemory: 512 MB
Up to 20Memory: 8 GB
CPU: 8 core
Disk: 100 GB		19 secondsMemory: 2 GBMemory: 1 GBMemory: 512 MBMemory: 512 MB
Up to 100Memory: 16 GB
CPU: 16 core
Disk: 100 GB		26 seconds

Memory: 4 GB

Configuration Settings:

spring.datasource.hikari.maximum-pool-size=50
Memory: 3 GBMemory: 1 GBMemory: 1 GB
Up to 1000Memory: 16 GB
CPU: 16 core
Disk: 100 GB		4 minutes

Memory: 5 GB

Configuration Settings:

spring.datasource.hikari.maximum-pool-size=150
server.jetty.max-threads=1000
query.engine.service.maxConcurrentRequests=1000

Memory: 4 GB

Configuration Settings:

server.jetty.max-threads=1000
Memory: 1 GBMemory: 1 GB