Skip to content

Latest commit

 

History

History
54 lines (40 loc) · 1.72 KB

File metadata and controls

54 lines (40 loc) · 1.72 KB
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
TSQL
helpviewer_keywords
hardware offload enable
HARDWARE_OFFLOAD
ms.reviewer david.pless, wiassaf
ms.technology configuration
ms.topic conceptual
author MikeRayMSFT
ms.author mikeray

Hardware offload enabled configuration option

[!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.

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)