Improve Performance by configuring Integrated acceleration and offloading with Intel® QuickAssist Technology (QAT) for SQL Server 2022

SQL Server 2022 (16.x) enables integrated offloading and acceleration with Intel® QuickAssist Technology (QAT). You can offload backup compression with Intel® QAT to reduce CPU usage, backup completion times, and reduce storage consumption. To back up or restore databases with accelerated compression, install Intel® QAT drivers. For specific information and instructions to use with SQL Server, see Configure Intel® QuickAssist Technology (QAT).

Integrated acceleration & offloading – SQL Server | Microsoft Learn

This is a new feature in SQL Server 2022.

Intel® QAT is an integrated acceleration and offloading solution.

The benefits are:

1- faster backup process

2- less CPU utilisation

3- less storage

to use this feature follow this Ms guide:

https://learn.microsoft.com/en-us/sql/relational-databases/integrated-acceleration/use-integrated-acceleration-and-offloading?view=sql-server-ver16

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.