Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

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

Reviews

Start your review of SQL Server & Intel - Unlock Better SQL Performance & Scalability

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.