Server Settings for Windows
Sisense Administrators have access to the Data Settings page located in the Data Sources section of the Admin page.
From the Data Settings page, Administrators can modify memory allocation, the number of simultaneous queries that can be handled, and query caching executed by Sisense.
Note: Sisense recommends consulting with Technical Support before changing the advanced settings.
You can modify the following settings:
|Default ElastiCube Data Location||The location of your ElastiCubes on your server. Sisense recommends storing ElastiCube data on a separate non-system drive.|
|Data Import Chunk Size (Rows)||The number of rows in every chunk imported when building an ElastiCube. This can be increased or decreased based on your build performance and network throughput.|
|R Server Address||The address of your R Server. By default, this feature is not activated. Click the toggle button to enable R server integration in Sisense and enter the IP address and port. Click Test to verify the connection to the R server. For more information about using R in Sisense, seeUsing R in Formulas.|
|Max ElastiCube Memory Allocation||The percentage of RAM out of the server's total RAM on the machine that can be allocated to each ElastiCube. By default, the value is set to Dynamic, which automatically allocates and frees memory in each ElastiCube to ensure stability and performance. Setting a static percentage will disable this mechanism.|
|Simultaneous Query Executions||The number of simultaneous queries that can be processed on a server across all ElastiCubes.This value is determined by half of the machine's vCPU cores.|
|Query Timeout (Seconds)||The maximum amount of seconds that must pass before a query times out.|
|ElastiCube Query Recycler||The ElastiCube Query Recycler caches similar and identical queries to the ElastiCube to reduce the amount of time to return a response. This reduces the amount of time it takes to process queries.This should be turned off for debugging purposes only.|