QuerySurge™ System Requirements
QuerySurge is an enterprise data testing solution that will typically be used to validate large data sets. Since you are testing either a Big Data store or Data Warehouse with potentially massive quantities of data, QuerySurge needs the right hardware to perform at speeds that will meet your team's needs.
Therefore, the more CPU, RAM and hard drive space you have, the better and faster QuerySurge performs.
For a trial setup, QuerySurge can be run on a desktop with modest resources (see tables below) but that will limit QuerySurge's performance and ability to scale.
For a production setup, we recommend the CPU have a minimum of 8 cores, which Intel’s Xeon chip and other manufacturers’ chips provide in two quad (4) core processors. For RAM, we recommend a minimum of 16 GB. For hard drive, we prefer solid state drives (SSD) over standard hard disk drives (HDD) as their performance can be upwards of 10x faster, but an HDD will work. For a production environment, one size does not fit all. Please see the variables that affect performance below and speak with our team before selecting a production deployment.
Performance Variables
There are variables that may impact performance to take into consideration when planning your QuerySurge deployment architecture:
- The proximity of the source and target databases to QuerySurge, i.e., whether they are on the same network. The closer they are, the faster the data loads into QuerySurge for analysis.
- Native installs/bare metal servers perform better than VMs due to inherent latency issues caused by additional computational layers.
- Utilizing Solid State Drives (SSD) over traditional Hard Disk Drives (HDD) can significantly increase QuerySurge’s performance, depending on the speed and generation of the SSD and if network latency issues are removed (see above).
- Splitting application and database servers can increase performance and reliability as more memory and other resources can be allocated to each component, but it is dependent on how your tests are set up.
- The number of concurrent, active testers that will be running tests.
- The number of QueryPairs that will be executed and the sizes of datasets (actual size in bytes or # of rows and columns).
- The number of agents that will be running. Agents are multi-threaded, with the default setting at 3 concurrent queries per agent (a configurable parameter).
Browser Support
| Browser | Version |
| Chrome1 | 16.0+ |
| Firefox1 | 15.0+ |
| Internet Explorer | IE 11 |
| Edge | 25+ |
1 Browser not supported on Linux desktop environments
Hardware
Below are minimum and recommended system requirements for the different setups - 2 for trial installations and 4 for production installations:
- Trial Installation - Minimum Requirements
- Trial Installation - Recommended Requirements
- Production Installation - Single Server Setup - Minimum Requirements
- Production Installation - Single Server Setup - Recommended Requirements
- Production Installation - Multi-Server Setup - Minimum Requirements
- Production Installation - Multi-Server Setup - Recommended Requirements
1. Trial/POC Installation - Minimum Deployment System Requirementsa
| Component1 | Installation | Supported Operating Systems (64-bit) |
CPU | Memory | Disk Space |
| QuerySurge (Application server, Database server, Agent) |
All components installed on single desktop or server | Windows 8.1,10, Windows Server: 2012/2012 R2/2016; RHEL 6/7/83; Fedora core 6/13-223 |
2 cores | 8 GB | 100 GB HDD4 |
a 32 bit installers are scheduled for end-of-life in Q4 2019. Only 64 bit installers will be available after EOL.
1 VM-deployment supported
3 Full Linux install required (minimal install not supported)
4 Solid-state drives, if available, are recommended to enhance performance
2. Trial/POC Installation - Recommended Deployment System Requirementsa
Note: One size does not fit all. Please feel free to speak or email with our team to size your optimal trial deployment environment.
| Component1 | Installation | Supported Operating Systems (64-bit) |
CPU | Memory | Disk Space |
| QuerySurge (Application server, Database server) |
App & Database server installed on single desktop or server |
Windows 8.1,10, Windows Server: 2012/2012 R2/2016; RHEL 6/7/83; Fedora core 6/13-223 |
4 cores minimum |
16 GB minimum |
minimum of 1 TB SSD4 (for data |
| QuerySurge Agent | Installed on separate desktop(s) to alleviate resource contention |
Windows 8.1,10, Windows Server 2012/2012 R2/2016; RHEL 6/7/83; Fedora core 6/13-223 |
2 cores | 4 GB | 20 GB HDD |
a 32 bit installers are scheduled for end-of-life in Q4 2019. Only 64 bit installers will be available after EOL.
1 VM-deployment supported
3 Full Linux install required (minimal install not supported)
4 Solid-state drives, if available, are recommended to enhance performance
5 An optional second drive that will be used for persistent data storage only; will separate persistent data from comparison engine
3. Production Installation - Minimum Deployment System Requirements – Single Server Setup
| Component1,2 | Installation | Supported Operating Systems (64-bit)3 |
CPU | Memory | Disk Space |
| QuerySurge (Application server, Database server)2 |
App & Database server installed on single desktop or server |
Windows 8.1,10, Windows Server: 2012/2012 R2/2016; RHEL 6/7/85; Fedora core 6/13-225 |
4 cores | 16 GB |
1 TB HDD (SSD Preferred)6 |
|
QuerySurge Agent |
Installed on separate desktop(s) to alleviate resource contention |
Windows 8.1,10, Windows Server: 2012/2012 R2/2016;; RHEL 6/7/85; Fedora core 6/13-225 |
2 cores | 4 GB | 20 GB HDD |
1 VM-deployment supported
2 Server hardware/OS recommended
3 Q4 2019: 64 bit arch only is supported
5 Full Linux install required (minimal install not supported)
6 Solid-state drives, if available, are recommended to enhance performance
4. Production Installation - Recommended Deployment System Requirements - Single Server Setup
Note: One size does not fit all. Please feel free to speak or email with our team to size your optimal trial deployment environment.
| Component1,2 | Installation | Supported Operating Systems (64-bit)3 |
CPU | Memory | Disk Space |
| QuerySurge (Application server, Database server)2 |
App & Database server installed on single desktop or server |
Windows 8.1,10, Windows Server: 2012/2012 R2/2016; RHEL 6/7/85; Fedora core 6/13-225 |
8 cores minimum |
32 GB minimum |
minimum of 1 TB SSD6 (for data storage and comparison engine) --------------- optional data storage drive7 (not required) minimum of 1 TB SSD6 or HDD |
|
QuerySurge Agent |
Installed on separate desktop(s) to alleviate resource contention |
Windows 8.1,10, Windows Server: 2012/2012 R2/2016; RHEL 6/7/85; Fedora core 6/13-225 |
2 cores | 8 GB | 20 GB HDD |
1 VM-deployment Supported
2 Server hardware/OS recommended
3 Q4 2019: 64 bit arch only is supported
5 Full Linux install required (minimal install not supported)
6 Solid-state drives, if available, are recommended to enhance performance
7 An optional second drive that is used for persistent data storage only; separates persistent data from comparison engine
5. Production Installation - Minimum Deployment System Requirements – Multi-Server Setup
| Component1,2 | Installation | Supported Operating Systems (64-bit)3 |
CPU | Memory | Disk Space |
|
QuerySurge Application server2 |
Installed on separate desktop or server to alleviate resource contention |
Windows 8.1,10, Windows Server: 2012/2012 R2/2016; RHEL 6/7/85; Fedora core 6/13-225 |
4 cores | 8 GB | 100 GB HDD6 |
| QuerySurge Database server2 | Installed on separate desktop or server to alleviate resource contention |
Windows 8.1,10, Windows Server: 2012/2012 R2/2016; RHEL 6/7/85; Fedora core 6/13-225 |
4 cores | 16 GB | 1 TB HDD6 |
|
QuerySurge Agent |
Installed on separate desktop(s) to alleviate resource contention |
Windows 8.1,10, Windows Server: 2012/2012 R2/2016; RHEL 6/7/85; Fedora core 6/13-225 |
2 cores | 8 GB | 20 GB HDD |
1 VM-deployment Supported
2 Server hardware/OS recommended
3 Q4 2019: 64 bit arch only is supported
5 Full Linux install required (minimal install not supported)
6 Solid-state drives, if available, are recommended to enhance performance
6. Production Installation - Recommended Deployment System Requirements - Multi-Server SetupNote: One size does not fit all. Please feel free to speak or email with our team to size your optimal trial deployment environment.
| Component1,2 | Installation | Supported Operating Systems (64-bit)3 |
CPU | Memory | Disk Space |
|
QuerySurge Application server2 |
Installed on separate desktop or server to alleviate resource contention |
Windows Server: 2012/2012 R2/2016; RHEL 6/7/85; Fedora core 6/13-225 |
4 cores minimum |
16 GB minimum |
100 GB HDD6 minimum |
| QuerySurge Database server2 | Installed on separate desktop or server to alleviate resource contention |
Windows Server: 2012/2012 R2/2016; RHEL 6/7/85; Fedora core 6/13-225 |
8 cores minimum |
32 GB minimum |
minimum of 1 TB SSD4 (for data storage and comparison engine) --------------- optional data storage drive7 (not required) minimum of 1 TB SSD6 or HDD |
|
QuerySurge Agent |
Installed on separate desktop(s) to alleviate resource contention |
Windows 8.1,10, Windows Server: 2012/2012 R2/2016; RHEL 6/7/85; Fedora core 6/13-225 |
2 cores | 8 GB | 20 GB HDD |
1 VM-deployment Supported
2 Server hardware/OS recommended
3 Java 8 is the last JVM release with 32 and 64 bit arch options; future JVMs are 64 bit only
5 Full Linux install required (minimal install not supported)
6 Solid-state drives, if available, are recommended to enhance performance
7 An optional second drive that will be used for persistent data storage only; will separate persistent data from comparison engine
Note: In-place Operating System upgrades are not supported. If you are planning an in-place upgrade, please contact QuerySurge support prior to your upgrade for information.
Please feel free to reach out to us for further questions on your QuerySurge setup.
These requirements are subject to change without notice.
Comments
0 comments
Please sign in to leave a comment.