This guide will walk you through the steps that are unique to Configure Your Own Server. If you are interested in a cloud-based deployment or to continue with the remaining configuration steps, please navigate to the overall guide: Configure your TimeXtender Environment.
When deploying on-premises there are 4 steps that you must accomplish before continuing on with the
- Choose and Deploy the desired Server Configuration
- Install the Necessary Prerequisites
- Configure User Accounts & Permissions
- Install TimeXtender
Choose and Deploy the desired Server Configuration
You have multiple options regarding server configuration depending on where you wish to house the TimeXtender application, Services, and SQL Server databases.
Consolidated BI Server |
In this configuration, the TimeXtender application, services and SQL Server databases are all installed on the same windows server. Due to the simplicity of this configuration, it is easier to maintain and offers some performance advantages due to zero network latency. |
Separate Application and Database Servers |
In this configuration, the TimeXtender application and services are installed on an "Application" server and the SQL Databases are stored on a separate "Database" server. In this configuration, we highly recommend you configure Remote Execution of SSIS Packages to transfer data directly from the source to the database server for significantly improved performance. |
Hardware Configuration
There are no minimum hardware requirements for TimeXtender beyond that which is required by Microsoft SQL Server. Analytics environments can be drastically different from one organization to the next and performance can be impacted by any number of factors. Because of this we highly recommend you conduct your own testing and/or obtain an expert recommendation from a qualified professional. With this in mind below are some general guidelines for optimal performance of TimeXtender.
Server | Hard Disk | 64-bit CPU | Ram |
Application Server | 256 GB SSD | 4 core | 16GB |
Greater Than 1TB of Source Data | 256 GB SSD | 4 core | 32GB |
Database Server | 1 TB SSD | 8 core | 32GB |
Greater Than 1TB of Source Data | 25 TB SSD | 16 core | 64GB |
Note: When creating your databases in SQL Server always be sure to place the data and log files on SEPARATE disks drives. Placing them on the same disk can create contention between the files resulting in poor performance. Placing them on separate disks means that they can be written to simultaneously ensuring optimal IO throughput.
Install the Necessary Prerequisites
Once you have chosen your desired configuration and deployed the necessary servers, you must install all the necessary TimeXtender Prerequisites.
Add Required Firewall Exceptions
Please configure your server(s) firewall to allow TimeXtender's List of Required Firewall Exceptions.
Configure User Accounts & Permissions
After installing the prerequisites, you must Configure User Accounts & Permissions.
Install TimeXtender
Finally, once the user accounts and permissions are in place, you can Install TimeXtender.
Once these steps are complete, you can continue with the remaining configuration steps in the overall guide: Configure your TimeXtender Environment.
0 Comments