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 On-Premise application server. When performing ADO.net transfer from a data source, data is passed through the application server then lands in the target SQL server database. Be sure the application server and network throughput can support moving the desired amount of data.
The project repository and target SQL databases are housed on a separate on-premise server specifically created for running SQL server.
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 & Configure Discovery Hub.
Once these steps are complete, you can continue with the remaining configuration steps in the overall guide: Configure your Discovery Hub Environment.