Combating Data Deluge on SQL Servers for Linux and Windows CitC Episode 190

Published: Oct. 9, 2019, 5 p.m.

Ken LeTourneau, Solutions Architect in Intel\u2019s Data Center Group, joins us on this week\u2019s Conversations in the Cloud to discuss Intel\xae Select Solutions for Microsoft SQL Server on Windows and Linux. \n\nKen highlights the major differences between versions of Intel\xae Select Solutions for Microsoft SQL Server. While the original designs were very workload focused, the version 2 solutions are built to be general purpose with multi-tenant environments in mind. The new design is based on Windows Server 2019 and incorporates Intel\xae Optane\u2122 DC persistent memory as well as Intel\xae Optane\u2122 Solid State Drives (SSD). Using persistent memory means high endurance and IOPS so customers can scale with the same quality of service. \n\nHe also discusses the SQL Server for Linux, which introduces multi-tenancy via containers. Users can stack containers onto servers, allowing more room to grow before a new server is needed. Linux for SQL Server is now supported by Microsoft and has performance parity with Windows. \n\nAs an architect, Ken feels that Intel\xae Select Solutions are a valuable approach for SQL servers because the verified hardware and software stacks are workload optimized. The designs are guided by relevant industry benchmarks and input from an ecosystem of partners. In addition, the prescriptive reference design gives partners high confidence in solution performance for end-users.\n\nData is doubling every 2 years and companies need to understand both its value and use. In the future, Ken expects to see a major change as companies are forced to adapt to their own data deluge.\nLearn more about SQL Server offerings and explore Intel\xae Select Solutions for Analytics at https://intel.com/selectsolutions.