SQL Server 2017 on Linux System Requirements & Software Prerequisites

SQL Server 2017 on Linux System Requirements & Software Prerequisites

If you have a mixed environment of Windows and Linux, you would be happy to know that Microsoft has now released SQL Server 2017 to work on Linux Operating systems, in addition to Windows. All the editions and features are available on both the platforms. It gives system integrators more flexibility to integrate SQL Server products. In case if you are interested in implementing SQL on Linux, you would need to know the Linux System Requirements first.

This blog post is precisely about that. In this post, we would be checking into the SQL Server 2017 on Linux System Requirements. So, let’s go ahead and check them out in more detail. But, before we get into the details, here are some value-adds for running SQL on Linux!

  • Windows-based SQL Server management tools— like SSMS, SSDT, and Profiler—work when connected to SQL Server on Linux
  • All existing drivers and frameworks are supported on Linux
  • Third-party tools continue to work over connection endpoints
  • Native command-line tools are supported: sqlcmd, bcp
  • Visual Studio Code mssql extension is supported
  • New command line tool: mssql-cli
  • New cross-platform management tool: SQL Operations Studio (SOS)

Related Reading: SQL Server 2017 Editions

SQL Server 2017 on Linux System Requirements

Since there are a wide variety of Linux distros available on the market, it is difficult to point out the exact system requirements. Microsoft has provided guidance on which ones to use, and we are going to list only those.

Here is the list of Linux Operating systems that are currently supported.

  • RedHat Enterprise Linux (7.3 & 7.4)
  • SUSE Linux Enterprise Server (v12-SP2)
  • Ubuntu (16.04 & 16.10)
  • Docker Engine (1.8 or higher)

Currently, SQL Server 2017 only supports XFS and ext4 file systems. Microsoft might release support for more file systems in the future.

On a high-level, here are the minimum Linux System Requirements as shown below:

Feature-TypeMinimum Linux System Requirements
Memory3.25 GB
File SystemXFS or EXT4 (other file systems, such as BTRFS, are unsupported)
Disk spaceMinimum of 6 GB
Processor speedClockspeed of 2 GHz or more
Processor Cores2 cores (Virtual or Physical)
Processor type64 bit x64-compatible CPU only

For NFS (Network File Share), you will need to use 4.2 or higher. Just the  /var/opt/mssql can be mounted on the NFS mount-point. NFS clients need to use the ‘no-lock‘ option to install on NFS shares.

Operational features

  • Support for Redhat RHEL, Ubuntu, SLES, Docker
  • Package-based installs
  • Support for OpenShift, Docker Swarm
  • Failover clustering via Pacemaker
  • Backup & Restore
  • SSMS on Windows connected to Linux – Cross Platform
  • Command-line tools: sqlcmd, bcp
  • Transparent Data Encryption (TDS)
  • Backup Encryption
  • SCOM Management Pack
  • Dynamic management views (DMVs)
  • Table partitioning
  • SQL Server Agent for Jobs
  • Full-Text Search
  • Integration Services
  • Active Directory integrated authentication
  • TLS for encrypted connections

Programming features

  • All major language driver compatibility
  • In-Memory OLTP
  • Columnstore indexes (CCI & NCCIs)
  • Query Store
  • Data Compression (Page & Row Levels)
  • Always Encrypted
  • Row-Level Security & Dynamic data masking
  • Auditing
  • Service Broker

SQL Server on Linux – Limitations on Features not currently supported

  • Transactional replication
  • Merge replication
  • Stretch DB
  • PolyBase
  • Distributed query with third-party connections
  • System extended stored procedures (XP_CMDSHELL, etc.)
  • Filetable, FILESTREAM
  • CLR assemblies with the EXTERNAL_ACCESS or UNSAFE permission set
  • Buffer Pool Extension
  • Database Mirroring
  • Extensible Key Management
  • Subsystems: CmdExec, PowerShell, Queue Reader, SSIS, SSAS, SSRS
  • Alerts
  • Log Reader Agent
  • Change Data Capture
  • Managed Backup
  • SQL Server Browser
  • SQL Server R Services
  • StreamInsight
  • Analysis Services
  • Reporting Services
  • Data Quality Services
  • Master Data Services

Conclusion

The Linux System Requirements discussed here are subject to change by Microsoft. To know in detail, please refer to the official documentation available on the Microsoft public site. See below:

Disclaimer: The Questions and Answers provided on https://www.gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose.