hardware-offload-enable-configuration-option.md

title	Hardware offload enabled server configuration option
description	Learn about the hardware offload enabled option.
author	MikeRayMSFT
ms.author	mikeray
ms.reviewer	david.pless, wiassaf
ms.date	08/17/2022
ms.service	sql
ms.subservice	configuration
ms.topic	conceptual
helpviewer_keywords	hardware offload enable HARDWARE_OFFLOAD
dev_langs	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)