Hardware offload enabled configuration option

Applies to: SQL Server 2022 (16.x)

The hardware offload enabled configuration option allows integrated acceleration and offloading with validated solutions from partners. For more information, see Integrated acceleration and offloading.

Changing option requires a restart.

Example

Set the server configuration option hardware offload enabled to 1. By default, this setting is 0. This setting is an advanced configuration option. To set this setting, run the following commands:

sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'hardware offload enabled', 1
GO
RECONFIGURE
GO

Note

If hardware offload enabled is disabled (0), all offloading and acceleration solutions are disabled.

Next steps

• sys.dm_server_accelerator_status
• Server configuration options (SQL Server)
• ALTER SERVER CONFIGURATION (Transact-SQL)