This guide will walk you through the steps that are unique to deploying Discovery Hub in an On-Premises environment. 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 Discovery Hub 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 Discovery Hub
Choose and Deploy the desired Server Configuration
You have multiple options regarding server configuration depending on where you wish to house the Discovery Hub application, Services, and SQL Server databases.
Condolidated BI Server
|In this configuration, the Discovery Hub 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 Discovery Hub 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.|
There are no minimum hardware requirements for Discovery Hub 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 Discovery Hub.
|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 Discovery Hub Prerequisites.
Configure User Accounts & Permissions
After installing the prerequisites, you must Configure User Accounts & Permissions.
Install Discovery Hub
Finally, once the user accounts and permissions are in place, you can Install Discovery Hub.
Once these steps are complete, you can continue with the remaining configuration steps in the overall guide: Configure your Discovery Hub Environment.