| title | hardware offload enable Server Configuration Option | Microsoft Docs | ||
|---|---|---|---|
| description | Learn about the "hardware offload enabled" option. | ||
| ms.custom | |||
| ms.date | 08/17/2022 | ||
| ms.prod | sql | ||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.reviewer | david.pless, wiassaf | ||
| ms.technology | configuration | ||
| ms.topic | conceptual | ||
| author | MikeRayMSFT | ||
| ms.author | mikeray |
[!INCLUDE sqlserver2022]
The hardware offload enabled configuration option allows integrated offloading and acceleration with validated solutions from partners. For more information, see Integrated offloading and acceleration.
This is an advanced option.
Changing option requires a restart.
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
GONote
If hardware offload enabled is disabled (0), all offloading and acceleration solutions are disabled.
sys.dm_server_accelerator_status