Adding Microsoft SQL Server to an ADS server

HenrySykes

Has anybody got any experience in having Microsoft SQL Server and data tools installed on the same server as ADS is installed on which uses SQL Lite, we were wondering if they would interfere with each other?

Josh Boxer

Unaware of any issues that this might cause.

Henry Simms

No specific problems with having a SQL Server instance + tools on the same server as Data Studio, and in fact we have deployments that use this same setup. I would recommend taking care to ensure that both SQL Server and Data Studio have sufficient system resources (disk space and memory) available. You might for example consider a separate data disk / partition for SQL server, and they may want to explicitly set the max heap space Data Studio can use (see https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/set-up/install-data-studio-on-windows/#memory-settings )