SQL Server & Intel - Unlock Better SQL Performance & Scalability
PASS Data Community Summit via YouTube
Overview
Explore the benefits of using SQL Server 2019/2022 with Intel technology in this 36-minute conference talk from PASS Data Community Summit. Discover how SQL Server leverages Intel Optaneâ„¢ Persistent Memory for improved scalability and Intel QuickAssist Technology for enhanced backup performance and capacity. Learn about new storage engine features in SQL Server 2022 and gain insights into addressing challenges posed by the ever-increasing volume of data. Delve into topics such as current infrastructure, data storage, persistent memory, InMemory features, SQL Server backup compression, and hardware offloading. Gain valuable knowledge on optimizing SQL performance and scalability to meet the demands of modern data processing.
Syllabus
Introduction
David Pless
Darren Frymath
Current Infrastructure
Data Storage
Persistent Memory
Intel Optane
InMemory Features
SQL Server Persistent Memory
SQL Server Backup Compression
Why Do We Care
Intel QAT
Enable Hardware Offloading
QIT Benchmarks
SQL 2022 Features
SQL 2022 Blog
Wrap Up
Final Thoughts
Taught by
PASS Data Community Summit