Sizing and deployment considerations

For optimum performance, we recommend the following:

For a single-server deployment:

Number of machines5,00025,00050,000
Benchmark configuration
Maximum downloads per hour5,00012,500025,000
ActiveEfficiency Server
CPU cores223
RAM4 GB6 GB8 GB
SQL Server instance max memory1 GB2 GB3 GB
Disk space required for database4.5 GB4.5 GB4.5 GB
SQL Server HDD requirements
ActiveEfficiency database MDF4 GB4 GB4 GB
ActiveEfficiency database LDF50 MB50 MB50 MB
TempDB MDF50 MB100 MB200 MB
TempDB LDF4 MB8 MB16 MB
For a distributed server deployment:

Number of machines50,000100,000200,000500,000
Benchmark configuration
Maximum downloads per hour25,00050,000100,000250,000
ActiveEfficiency server
CPU cores1236
RAM4 GB4 GB4 GB4 GB
ActiveEfficiency database
CPU cores2236
RAM6 GB8 GB8 GB10 GB
SQL Server instance max memory3 GB4 GB4 GB6 GB
Disk space required for database4.5 GB5 GB6 GB9 GB
SQL Server HDD requirements
ActiveEfficiency database MDF4 GB4 GB4 GB8 GB
ActiveEfficiency database LDF50 MB250 MB500 MB1 GB
TempDB MDF200 MB400 MB1 GB1.5 GB
TempDB LDF16 MB32 MB64 MB100 MB

Benchmarking criteria

  • Benchmarked against Windows Server 2012 R2 Hyper-V infrastructure, with database and application server components on separate virtual machines
  • CPU – Hyper-V host CPU configuration: 2x Intel Xeon CPU E5-2407 v2 @ 2.40GHz, 10M Cache, 4C, Max Mem 1333MHz
  • Networking – virtual machines connected over a 1Gbps link through a 1Gbps physical switch
  • Database storage – Samsung 850 EVO solid state drives (SSDs) attached locally to the Hyper-V host with up to 98k/90k IOPS (4K random read/write QD32), and MDF, LDF and TempDB on separate SSDs 

Recommendations

  • Servers can be deployed either on physical or virtual machines. For deployment on a virtual machine, assign the CPU cores at 100% virtual machine reserve
  • Database Server:
    • deploy data, logs and TempDB on separate physical disks
    • configure SQL Server with maximum server memory limit and not at the defaults to consume unlimited memory
    • for sizing the Database server in the recommendations above, up to 4GB RAM has been added for the operating system on top of SQL Server instance RAM requirements.