hardware-offload-enable-configuration-option.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords	dev_langs
Hardware offload enabled server configuration option	Learn about the hardware offload enabled option.	MikeRayMSFT	mikeray	david.pless, wiassaf	08/17/2022	sql	configuration	conceptual	hardware offload enable HARDWARE_OFFLOAD	TSQL

Hardware offload enabled configuration option

[!INCLUDE sqlserver2022]

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)