Sign in

Database Server

March 9, 2026 10:52 AM
1 min read

Database Engine: Microsoft SQL Server 2016, 2017, 2019, or 2022.
Network OS: Any supported OS platform for a selected database.
CPU: Recommended 32 logical cores for up to 1000 users.
Minimum 16 logical cores for up to 250 users.
Memory: Recommended 64 GB RAM for up to 1000 users.
Minimum 32 GB RAM for up to 250 users.
HDD: Recommended RAID using 4 to 6 physically separate disks (RAID 0/1). Striping data across disks improves performance.

Note
NEVER use OS-based mirroring of the database—an OS should be on a separate disk from a database.

It is recommended that an operating system and virtual memory file should be separated from SQL server data and log files. Optimal SQL server performance is achieved when the SQL server log files also reside on a separate physical disk. The following recommended guideline is a good price and performance compromise:

  • Operating System disks: could be RAID 1.
  • SQL Server data files: RAID 5 array, minimum of 3 drives.
  • SQL Server log files: RAID 1 array, 2 drives.
  • There should be 1 temp database per physical core up to but not more than 8 temp databases.
  • Disks for data and log files should be higher than 1000 IOPS. Disk speed impacts the performance of concurrent users.