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.
SQL Server & Intel - Unlock Better SQL Performance & Scalability
PASS Data Community Summit via YouTube
Overview
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
Related Courses
-
High Availability - Disaster Recovery 101 - Data Architecture
-
Optane Storage and Memory Technology
-
SQL Server 2008 EOS Is Coming - Part II - Modernizing Your Data Platform
-
Turbocharge Your SQL Server with In-Memory Database
-
Improving Performance of Flash Based Key-Value Stores Using Storage Class Memory as a Volatile Memory Extension
-
SQL Server 2022 Storage Engine Capabilities
