This guide will walk you through the steps that to Configure an On-Prem 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 Data Integration Environment.
Follow the below steps to configure an On-Prem Server.
Choose and Deploy the desired Server Configuration
You have multiple options regarding server configuration depending on where you wish to house the TimeXtender Data Integration application, Services, and SQL Server databases.
Consolidated BI Server
- TimeXtender services and SQL Server databases are all installed on the same windows server.
- This setup is easier to maintain and offers some performance advantages due to zero network latency.
Separate Application and Database Servers
- TimeXtender services are installed on an "Application" server and the SQL Databases are stored on a separate "Database" server.
- This setup can mitigate risk be ensuring additional applications aren't installed and users don't need to sign in to the database server.
Hardware Configuration
There are no minimum hardware requirements for TimeXtender Data Integration 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 TimeXtender Data Integration and Setup Instances
Install TimeXtender Data Integration, TimeXtender Ingest service, and TimeXtender Execution service on your Application Server and then setup your instances. For more information see the below article:
