SQL Server database server

Component

Requirements

Computer and processor

8-core, 2 GHz or greater Intel Xeon processor or AMD equivalent

Memory

32 GB minimum

For information about SQL Server recommendations, see https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server (for 2016 or 2017)

Storage

For information about disk space requirements, see https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server (for 2016 or 2017)

Database and cubes (minimum specifications):

IOPS:  2,500

Temp database: RAID 0

Database data: RAID 5 or 6

Database log: RAID 1

Cube data: RAID 5 or 6

Cube log: RAID 1

High-performance specifications:

IOPS: 3,500

Temp database: RAID 0

Database data: RAID 10

Database log: RAID 10

Cube data: RAID 10

Cube log: RAID 10

Operating system

Windows Server 2019 (Standard or Datacenter Edition)

Windows Server 2022 (Standard or Datacenter Edition)

Database software

SQL Server 2017 CU28 or higher (Standard or Enterprise Edition)

SQL Server 2019 CU16 or higher (Standard or Enterprise Edition)

SQL Server 2019 or higher (Standard or Enterprise Edition)

SQL Server 2022

Note: Cluster services is supported and optional.

SQL Server Always On Availability Groups is supported only for SQL Server 2017 or higher. This requires special configuration. To request assistance from the Nuix Discover Technical Services team, submit a request on the Nuix Support Portal, located at: https://nuix.service-now.com/support.

Note: If you install the SQL Server Analysis Services server database on the same server as the SQL Server database, use additional processors and RAM.

Note: SQL Server as a Service, such as Amazon RDS or Azure Database, is not supported at this time.

Network

Gigabit Ethernet

Database Utility

Operating Systems Supported:

Windows Server 2019 (Standard or Datacenter Edition)

Windows Server 2022 (Standard or Datacenter Edition)