Page Comparison

MSSQL 2016 SP1 - Standard or Enterprise (Preferred)

1. Hardware and Software Requirements for MSSQL 2016 SP1
2. Feature Pack details for MSSQL 2016 SP1
3. Release Notes MSSQL 2016
4. Whats New in MSSQL 2016
5. MSSQL 2016 SP1 Server and Client Configuration Recommendations
   
   

MSSQL 2014 R2 - Enterprise edition

1. Hardware and Software Requirements for Installing SQL Server 2014
2. Feature Pack details for MSSQL 2016 SP1
3. Release Notes MSSQL 2014
4. Whats New in MSSQL 2014

MSSQL Server Recommendations for success

• MSSQL datasets on average are 4-6 times larger than PSQL 
  • (20 user, 5 location systems should expect aprox 10 GB production dataset)
• All datasets are managed within the same MSSQL "Multi-Tenant" database
• Minimum AGRIS hardware requirements will vary based on the size of your organization and datasets.   
  • Minimum recommended 12 GB Ram  
  • Minimum processor speed 3GHz
    • See also MSSQL Hardware and Software Requirements for Installing SQL Server
• Running SQL Server on a virtual machine will be slower than running natively because of the overhead of virtualization. 
• The MSSQL database engine server should be setup and configured as a single task server, focused on MSSQL database operation.   AGRIS or other Other applications and AGRIS should not NOT be installed on the same server as the MSSQL database engine server for optimum performance. 
• The use of Azure is not currently supported nor has testing for optimum configuration been completed for AGRIS using MSSQL.
• The MSSQL, AGRIS Application Servers, Terminal servers should be installed and operating within the same server network and cluster for optimum performance. 
• A test environment should be configured and reviewed by key members prior to going live with AGRIS on MSSQL to understand / ensure server and network performance is optimized for "live" use within your network.
• Network communication speeds may impact end user experience. 
• Review the following details for planning your install.
  • Planning a MSSQL Server Installation.

MSSQL Client expectations and sizing.

1. Greenstone has observed the following AGRIS Quantum on MSSQL client resource consumption in our testing environments:

   1. The memory consumption for one AGRIS Quantum on MSSQL client fluctuates between 128 MB and 480 MB.

   2. The memory consumption depends on the areas of the system you are running. 

   3. The highest memory consumption was observed when running large reports (100,000+ records).

   4. The memory consumption averages 240 MB when not executing large reports.

2. The CPU load while running one client was between 1% and 4%.

3. Peak CPU consumption was achieved when navigating a data grid with a large number of rows (5000+).•
4. We have experienced a 3% increment of CPU load per additional instance of AGRIS running on the same machine performing the same operation concurrently.

Our AGRIS

on MSSQL client testing environment is based on real hardware (non-virtualized) with the following specifications: 

• • • PC Model Asus G10AC
    • Processor Intel i7 - 4770 CPU @ 3.40 GHz
    • Memory 32 GB
    • OS 64-bit Windows Server 2012
    • R2 Standard Edition
    • Hard Drive 1 TB 1TB SATA hard drive (7200 RPM)
    • Network RJ45 LAN (10/100/1000)