Versions Compared

Old Version 19

changes.mady.by.user Russell Shirley

Saved on

compared with

New Version 20

changes.mady.by.user Russell Shirley

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Resources:

  • SQL Server Storage Best Practices


    • MSSQL

    Backup Best Practices

    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


    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



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

    Info

    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

    Filter by label (Content by label)
    showLabelsfalse
    max5
    spacesACD
    showSpacefalse
    sortmodified
    reversetrue
    typepage
    cqllabel = "mssql" and type = "page" and space = "ACD"
    labelsMSSQL

    Page Properties
    hiddentrue
    Related issues