Thursday 4 February 2021

Installation guidance for MS SQL Server on Linux

This article provides guidance for installing, updating, and uninstalling SQL Server 2017 and SQL Server 2019 preview on Linux.
Prerequisites
You must have a RHEL 7.3, 7.4, 7.5, or 7.6 machine with at least 2 GB of memory.

Supported platforms

SQL Server 2017 is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and Ubuntu. It is also supported as a Docker image, which can run on Docker Engine on Linux or Docker for Windows/Mac.
PlatformSupported version(s)Get
Red Hat Enterprise Linux7.3, 7.4, 7.5, 7.6Get RHEL 7.6
SUSE Linux Enterprise Serverv12 SP2Get SLES v12 SP2
Ubuntu16.04Get Ubuntu 16.04
Docker Engine1.8+Get Docker

System requirements

SQL Server 2017 has the following system requirements for Linux:
Memory2 GB
File SystemXFS or EXT4 (other file systems, such as BTRFS, are unsupported)
Disk space6 GB
Processor speed2 GHz
Processor cores2 cores
Processor typex64-compatible only
If you use Network File System (NFS) remote shares in production, note the following support requirements:
  • Use NFS version 4.2 or higher. Older versions of NFS do not support required features, such as fallocate and sparse file creation, common to modern file systems.
  • Locate only the /var/opt/mssql directories on the NFS mount. Other files, such as the SQL Server system binaries, are not supported.
  • Ensure that NFS clients use the 'nolock' option when mounting the remote share.

What is RAID ?

  What is RAID?   RAID Levels - How the drives are organized   How to determine your RAID level  RAID 0 - Disk Striping   RAID 1 - Disk Mirr...

most viewed