MSSQL Server and Client Configuration Recommendations

MSSQL 2016 Standard or Enterprise versions - Service Pack 1 or higher

(Note: MSSQL 2016 requires use of Server 2012 or higher to operate)

MSSQL 2014 Standard or Enterprise R2

(Note: To enable the AGRIS AUDIT tool MSSQL 2014 Enterprise or higher is required (Available in 2017))

MSSQL 2016 SP1 - Standard or Enterprise (Preferred)

Greenstone has observed the following AGRIS Quantum client resource consumption in our testing environments:
1. The memory consumption for one AGRIS Quantum 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.
The CPU load while running one client was between 1% and 4%.
Peak CPU consumption was achived when navigating a data grid with a large number of rows (5000+).•
We have experienced a 3% increment of CPU load per additional instance of AGRIS running on the same machine performing the same operation concurrently.

NOTE: If you foresee the need to perform audits of the database, consider using MSSQL 2016 Service Pack 1 Standard/Enterprise Editions

News you can use...

What should I expect the size per dataset to bet when migrating from PSSQL to MSSQL? Typically the database size will increase by roughly ~4-5X the current size of the pervasive files located in each dataset folder.
What about using MSSQL Express? In most cases, the typical AGRIS database exceeds the capacity for SQL Server Express.
- SQL Server 2014 Express - Limitations: Microsoft SQL Server Express supports 1 physical processor, 1 GB memory, and 10 GB storage.
  https://msdn.microsoft.com/en-us/sqlserver2014express.aspx