SQL Server & Intel - Unlock Better SQL Performance & Scalability
PASS Data Community Summit via YouTube
Learn AI, Data Science & Business — Earn Certificates That Get You Hired
You’re only 3 weeks away from a new language
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This session examines how SQL Server 2019 and 2022 use Intel Optane persistent memory and QuickAssist Technology to improve scalability and backup performance. It also highlights new SQL Server 2022 storage engine features.
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