~/talk

Platform Innovations with SQL Server 2022 + Intel

on YouTube 49m
Talkat SQLBits 2023 · 2023-03-14..03-18· [databases]

speakers

name:Darren Freimuth
links:none on file
name:Bob Ward
linkedin:bobwardms

resources

video:https://youtu.be/9L912s6nXkc
slides:none on file

summary

SQL Server 2022 adds native integration with Intel Quick Assist Technology so backups can offload compression to hardware or fall back to software; demo shows CPU use dropping from ~94% to ~3% and PCIe 8970 offload giving ~2.3× faster backups (on-chip Sapphire Rapids shows up to 3.2x faster), with ~6% smaller files reported. AVX‑512 can be enabled via trace flag 15097 to accelerate read‑only batch mode columnstore. Restores require QAT drivers present; a DMV and error log show accelerator state.

AI-written summary · about

chapters (5)

  1. 0:00Start
  2. 3:44SQL Server 2022 capabilities
  3. 9:26Hardware acceleration for backup compression
  4. 18:40Best Practices for Stability
  5. 36:053rd Gen Intel Xeon Scalable Processor vs 4th Gen Intel Scalable Processor comparison -SQL Server 2022 OLTP & DSS workloads

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.