- 07 Sep 2022
- 9 Minutes to read
Windows Minimum Requirements
- Updated on 07 Sep 2022
- 9 Minutes to read
This page includes prerequisites and supported platforms that are required when working with Sisense on Windows.
Below you can find links to the section relevant for you:
Supported Web Browsers
The Sisense Web Application runs in the following HTML5 supported browsers:
- Edge (only Chromium-based, version 79 and later)
- Google Chrome
- Safari version 7 and later
When embedding iFrames, Sisense supports Safari 10 and later.
Internet Explorer 11
If you are using Internet Explorer 11, Sisense recommends moving to another browser. Microsoft ended IE11 support for various Microsoft products during 2021 and Sisense stopped supporting IE11 by the end of 2021.
IE11 is not supported for the Sisense internal web-based file browser application.
The Sisense Web Application also works in mobile phone and tablet browsers that support HTML5. Click Viewing Dashboards on Mobile Devices to learn more about mobile compatibility.
Windows Operating System Requirements
The ElastiCube Server and ElastiCube Manager can be installed on the following 64-bit operating systems:
- Windows 7, Windows 10
- Windows Server 2008 R2 through Windows Server 2019
If you are installing Sisense in Windows Server 2019, see Disabling Windows Defender Real-Time Protection.
While Sisense supports different versions of Windows, it is highly recommended that your production environments use Windows Server 2008 R2 and later.
Sisense scales up to billions of records with typical query response times in under a few seconds.
This section suggests hardware requirements for various performance capacities of the ElastiCube Server when connecting to data sources with Live connections or importing data into an ElastiCube. Actual capacity requirements are provided after consultation with Sisense. Extreme scenarios may require additional resources.
Note the following:
- For Sisense Viewers, only an HTML5 compliant web browser is required.
- For cloud deployments, regardless if you are using AWS/Azure/Rackspace/etc., you must choose a machine that meets the recommended hardware configuration described in the table below.
When connecting to a Sisense Live data source, Sisense recommends a minimum of 16GB memory with 8 cores. For use cases with 100s of users concurrently connecting to your data source, contact your CSM for more information about Sisense's minimum requirements.
You can create up to 400 Live models on one Sisense instance.
The table below describes the minimum requirements for your production Sisense Server responsible for managing ElastiCubes. It is important to note that it is possible to exceed the large-scale machine deployment size given in the table below with machines that have more memory and cores.
|Deployment Size||Small Scale||Medium Scale||Large Scale|
8 Logical Cores
16 Logical Cores
32 Logical Cores
64GB - 128GB
256GB - 512GB
Sisense Installation Directory
ElastiCube Data Directory
Application Logs Directory
Sisense recommends that your Sisense server meets or exceeds the recommendations listed above. The actual requirements of your Sisense server may vary depending on the number of concurrent users, builds running in parallel, number of ElastiCubes hosted on a server, the complexity of the ElastiCube s, and additional factors specific to your server, for example, non-Sisense applications running on the same server. When deploying Sisense on a single server, it is recommended to plan in advance for possible additions (for example free slots for RAM or hard disk) on physical machines or virtual scale up (for example adding computing resources) on virtual machines. It is also highly recommended to use a dedicated machine (physical or virtual) and refrain from using the Sisense server for other services.
The following table lists sizing recommendations for a Sisense installation deployed on a single Windows server, based on average use cases and hardware demands. The specific recommendations depend on the specific query load patterns and use cases.
If you find that you are running in the upper limits of the large-scale recommendations, consider splitting the server functionality into multiple nodes or a Linux architecture deployment. For more information, see Sisense Architecture.
Concurrently Active Users
Number of tables per ElastiCube
Parallel ElasticCubes Build Processes
Max Number of rows per Table
Number of Custom Tables in an ElastiCube
Number of Custom Columns in an ElastiCube
Number of Different Sources (Connectors) per ElastiCube
With typical BI usage, the ratio of total users to concurrently active users is about 1 to 20. The query load on the server is primarily determined by the average number of queries per second. Systems that use Sisense dashboards operationally, may have a higher amount of queries per second, and require additional resources to manage this load.
Expected Usage for a Single Machine
Sisense customers vary in terms of production deployments that represent different needs. The following is typical usage for a single Windows machine, which can serve as a good indication of the typical single machine load. Such a machine will be mid-scale or large-scale, depending on the number of concurrent users and the load of the build process. If your expected usage is approaching the maximum values, consider splitting the server functionality into multiple nodes or a Linux architecture deployment. For more information, see Sisense Architecture.
Note that maximum values represent the maximum load tested in different scenarios, however, there is no hard limit that will prevent a Sisense system on a single machine from crossing these values*(1).
Number of ElastiCubes
Number of Tables per ElastiCube
Data Size (Total ElastiCubes)
*(1) Appropriate license may be required to reach a certain load. For example, the number of maximum rows in a table can be limited by the purchased Sisense license regardless of the system capabilities.
The following are some considerations to take into account when deploying Sisense:
Each Sisense widget produces at least one query to the ElastiCube or Live source when viewed. As a dashboard is a collection of widgets, viewing a dashboard produces multiple queries, which in turn raises CPU usage. Concurrent queries affect CPU utilization and are independently spread between different CPUs. While this concurrency is a core activity of Sisense, it is important to consider the correlation between the number of concurrent users/active dashboards and increasing CPU usage. It is especially important to track CPU usage when increasing the number of concurrent users or active dashboards. Lack of CPU resources will cause dashboards to load slowly. When CPU usage consistently increases above 80%, it is recommended to add CPU resources.
In addition, custom tables and custom columns will increase the CPU load at the end of a build process according to the complexity of the functions used by those custom tables and columns. In this case, adding more CPU resources will help to decrease the total build time.
Building an ElastiCube can consume a lot of CPU resources. However, CPU consumption is not linear while performing parallel builds, and it is possible to run several builds at the same time. A single Windows server supports up to four parallel builds. Sisense is typically capable of running four parallel builds while consuming only half of the CPU resources compared to the same builds run separately. It is possible to run build processes and view dashboards at the same time, however, as both are CPU consumers, Sisense recommends that you schedule builds to run at times of low dashboard viewing, like during the night.
Building ElastiCubes and viewing dashboards both require memory. While it is possible to view dashboards at the same time as running build processes, the RAM resources required for those activities will be aggregated. When using a single-server Sisense deployment, it is important to take both into account and plan RAM usage accordingly. To prevent out-of-memory build failures, it is advisable to run the build process at low-usage schedules or separate the build and the query nodes to different machines.
The size of your ElastiCube model has a major impact on the memory consumption of a Sisense server during a build and query. This is equally true when considering the row-count per table, the number of tables, or a combination of the two in an ElastiCube model. Memory consumption often peaks when building a custom table. Columns with unique data types, like strings, which are indexed during the build process, are cached in memory, for example, large string columns with many unique values may increase memory consumption.
There is a correlation between the data size on the disk and the required RAM. Sisense InChip© technology will load large portions of the ElastiCube to the memory hence the number of active cubes and the cubes total size is a very important sizing factor for the RAM size.
Disk Space Considerations
The Sisense installation file is typically around 1.5GB in size. Once Sisense is installed, Sisense uses about 20GB of space. In general, when determining how much disk space to reserve for Sisense, keep in mind the size of the data to be imported into your ElastiCube models. You should keep additional space to support your ElastiCube models, as these are duplicated during the build process. The duplicate copy is not removed at the end of the build process but serves as the basis of the next build.
An additional important consideration is the custom columns and tables, which are materialized on the disk during the build process. Hence it is important to add the required disk space for these data to the total estimated data size.
In addition to the imported data size, the ElastiCube also holds metadata like indexes. Actual cube size on the disk will be extended due to this internal metadata, hence it is good practice to plan for 20% overhead on top of the imported data and custom tables.
Typically the ElastiCube data is stored compressed. However, it is good practice to plan for the required disk size without taking the compression into account, since in different scenarios one may choose to disable the data compression for build and query performance improvements.
If you need to store your ElastiCube models in another location other than the default C drive, see Change the Location of ElastiCube Data Folders.
For staging or demo environments, consider using high-speed hard disks (e.g. 7200RPM+) for the home directory and backups, while for production environments, use Solid State Disks (SSD) utilizing NVMe to ensure high I/O performance.
Page File Considerations
Windows OS page size settings have an effect on performance and should be considered. The default recommendation is to set the page size to 150% of the RAM size. When possible, and disk space is not an issue, Sisense recommends setting the page size to 300% of the RAM size. By extending the page size one can use storage resources to avoid out-of-memory errors but need to consider that when paging is used the system will respond slower. In a large system with 128GB RAM or more, it is not always feasible to set a huge amount of page file on the server as it requires very large disk space. For the server's with a large amount of RAM, you might want to limit the page file size equal to 128 GB at least.
In addition, it is recommended to split page files on two different drives (preferably on two different physical/virtual disks) on the server for better disk I/O performance.
Data Sources Considerations
Connectors affect memory consumption linearly. The usage of each connector has a predefined (and configurable) memory allocation, hence increasing the number of different connectors which are used during the build process increases the memory consumption.