How to Enable Intel QAT Backup Compression in SQL Server 2022

[@pratiqwaghela]

Sir Glenn, 201 seconds for 1TB database is pretty good. Nice to see that Microsoft has open this feature to be used for standard edition too. Thank you for clearing the doubt that it cannot be used without intel hardware. Subscribed and looking forward to the new uploads 🙂

[@GlennBerrySQL]

Thanks for the comment! This is an interesting new feature that does work in Standard Edition

[@FrankThiessen-z1n]

Very interesting. Glenn do you have any idea what changes regarding compression ratio and performance when QAT HW is present?

[@GlennBerrySQL]

With QAT hardware, the compression ratio is usually slightly higher than with QAT software mode, but the difference is usually very small. With a QAT 8970 PCIe card, QAT hardware mode is usually much slower than with QAT software mode, but this depends on how fast your processor cores are and how many stripes are in the backup.
The advantage of QAT hardware mode is that your regular CPU utilization during a database backup will be much lower than with QAT software mode, since the QAT device is doing the compression.

[@stevenwheeler541]

Thanks Glen for posting. Working on adding this into dev environment now. One question, I am assuming that a database backed up using QAT would need to have QAT installed before restoring to another SQL 2022 instance.

[@GlennBerrySQL]

Yes, that is correct. You will have to install the Intel QAT drivers and also go through the steps in the video to enable QAT on any SQL Server 2022 instance where you wanted to restore a QAT backup.

[@tanmaypanadi1414]

level1techs comment sent me here. 👍

[@GlennBerrySQL]

Thanks for coming

[@TETNTM]

yoo new upload

[@GlennBerrySQL]

Thanks for watching!