Press "Enter" to skip to content

Intel Quick Assist Technology and SQL Server Backups

Andy Yun notes a nice feature in SQL Server 2022:

Using QAT compression for your native SQL Server backups will give you better compression with less CPU overhead, than “legacy” compression. So I get smaller backup files, faster, with less CPU burn. What’s there to not like?

There’s a lot to dig into with this post and a special note on Transparent Data Encryption at the end.