Microsoft Bolsters Performance of SQL Server Database on Linux
The new SQL Server preview for Linux includes a bump in T-SQL module performance and expanded Linux OS support.Microsoft made waves earlier this year when it announced that its SQL Server database was heading to Linux in mid-2017. For an early peek at what that experience is like, curious database administrators can download a beta release of the software. Version 1.1 of the so-called SQL Server vNext Community Technology Preview (CTP), released nearly a month after the first preview, contains several performance enhancements and supports more Linux distributions. The new vNext branding is meant to evoke SQL Server's evolution from a Windows-only technology to a cloud-enabled, Linux and container-friendly data platform. The upcoming release of SQL Server vNext for Linux is one of several moves the software giant is making to court the open source community and developers who make extensive use of Linux to build solutions for the enterprise. "SQL Server vNext represents a major step towards making SQL Server a platform that gives you choices of development languages, data types, on-premises and in the cloud, and across operating systems by bringing the power of SQL Server to Linux, Linux-based Docker containers, and Windows," stated Microsoft in an online support document. On Linux, SQL Server vNext CTP 1.1 features language enhancements and a performance boost for T-SQL (Transact-SQL) modules that have been natively compiled. The early-access software also can update non-clustered columnstore indexes faster, particularly when the row is in the performance-enhancing delta store clustered index.
Memory grant feedback loops, a memory-optimization feature that analyses memory use as queries are being executed, is now supported in batch mode queries. The update also includes new T-SQL language additions, including the TRIM, CONCAT_WS and TRANSLATE string functions.