Server configuration: hardware offload enabled

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.

Examples

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:

EXECUTE sp_configure 'show advanced options', 1;
GO

RECONFIGURE;
GO

EXECUTE sp_configure 'hardware offload enabled', 1;
GO

RECONFIGURE;
GO

Note

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

Related content

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