How to Enable Intel QAT Backup Compression in SQL Server 2022
This video describes and demonstrates how to enable Intel QAT Backup Compression in SQL Server 2022. This is a new feature in SQL Server 2022 that lets you use Intel QAT backup compression for compressed database backups.
Intel QAT backup compression has two modes, software mode and hardware mode. Software mode does not require any specialized Intel hardware and is supported in SQL Server 2022 Standard Edition.
Hardware mode does require QAT capable hardware and is only supported in in SQL Server 2022 Enterprise Edition.
Whether you have QAT capable hardware or not, enabling Intel QAT Backup Compression is very easy (as shown in the video). There are three main steps:
1. Install the latest Intel QAT drivers and restart SQL Server
2. Run an sp_configure command and restart SQL Server
3. Run an ALTER SERVER CONFIGURATION command and restart SQL Server
I have a blog post that reinforces this video:
How to Enable Intel QAT Backup Compression in SQL Server 2022
https://glennsqlperformance.com/2022/...
⏱️TIMESTAMPS⏱️
0:00 Intro
0:16 Initial configuration
2:08 Installing the Intel QAT Driver
4:19 Enabling Intel QAT Backup Compression in SQL Server 2022
9:57 What is the benefit of Intel QAT Backup Compression?
13:23 Outro
13:40 Bonus Chorizo content!
🔴 Subscribe for more content like this
Links to Amazon are typically monetized on my channel (affiliate links) and may return a commission of sales to me from the retailer. This is unrelated to the product manufacturer.
SOCIAL
===============================
📝 - BLOG: https://glennsqlperformance.com/
🐦 - TWITTER: / glennalanberry
👥 - FACEBOOK: / glenn.berry.92
LinkedIn: / glberry
Host, Video: Glenn Berry
Watch video How to Enable Intel QAT Backup Compression in SQL Server 2022 online, duration hours minute second in high quality that is uploaded to the channel Glenn Berry 23 October 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 686 times and liked it 31 visitors.
