Limitations of SQL Server on Linux include:
- SQL Server Reporting Services (SSRS) is not available for installation on Linux.
- SQL Server Management Studio (SSMS) must be on the Microsoft Windows platform.
- SQL Server on Linux currently supports ext4 and XFS. Microsoft will add support for other file systems later, as needed.
- In our testing, SQL Server on Linux and Linux Docker containers appeared to consume CPU and memory resources similar to Windows 2017 for the same level of database performance. SQL Server on Linux consumed 11 percent more CPU compared to Windows for the same number of transactions per second. Minimum CPU and memory requirements for the Linux installation of SQL Server are higher compared to Windows. For up-to-date information on software and hardware requirements, see the latest SQL Server release notes.