AGRIS Customer Documentation

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 20 Next »

Recommended version 

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

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

Minimum Required Version

MSSQL 2014 Standard or Enterprise 

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




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...

  • Curious about testing using MSSQL express? In most cases, the typical AGRIS database exceeds the capacity for SQL Server Express.
  • Typically the database size will increase by roughly ~4-5X the current pervasive size for each dataset.


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


Other Resources:

  1. SQL Server Storage Best Practices
  2. MSSQL Backup Best Practices

  • No labels