sys.dm_server_accelerator_status (Transact-SQL)
Applies to:
SQL Server 2022 (16.x)
Returns information about integrated offload and acceleration solutions that are available to the current instance of SQL Server. Introduced in SQL Server 2022 (16.x).
Use this view to identify the available accelerators, the current mode description reason, the hardware availability, the libraries, the drivers configured for use and confirmed to be loaded. Use mode_reason_desc
to verify and troubleshoot the state of the available accelerators.
Column name | Data type | Description |
---|---|---|
accelerator | nvarchar(60) | Available accelerator. |
accelerator_desc | nvarchar(60) | Description of available accelerators. |
mode_desc | nvarchar(60) | The description of the mode. |
mode_reason_desc | nvarchar(60) | The reason for the mode, used for troubleshooting. NONE_HARDWARE_OFFLOAD_NOT_ENABLED (0) – Status when the hardware offloading is not enabled on the instance. This status is the default on a Windows Server when the sp_configure 'hardware_offload_config' command has not been enabled.NONE_HARDWARE_OFFLOAD_LINUX_NOT_SUPPORTED (1) – The current message on Linux platforms as Intel® QuickAssist Technology (QAT) is currently not supported. NONE_ACCELERATOR_CONFIG_NOT_ENABLED (2) – The 'hardware_offload_config' may be configured, but the Intel® QAT accelerator mode is not enabled via the ALTER SERVER CONIGURATION command. For example: ALTER SERVER CONFIGURATION SET HARDWARE_OFFLOAD = ON (ACCELERATOR = QAT) NONE_ACCELERATOR_LOAD_FAILED (3) – There is a failure loading qatzip.dll that is part of the driver solution. For support resources, see Support. NONE_ACCELERATOR_PROC_FAILED (4) – There is a failure locating proc addresses in qatzip.dll that is part of the driver solution. For support resources, see Support. NONE_ACCELERATOR_VERSION_NOT_COMPATIBLE (7) – The installed qatzip.dll and isa-l.dll versions are not compatible with SQL Server. Install the latest supported version of the drivers from Intel®.NONE_ACCELERATOR_INITIALIZATION_FAILED (8) – There was a failure initializing the Intel® QAT accelerator. It is recommended to check the error log for the availability of the hardware, and the Intel® QAT driver and library versions. For support resources, see Support. NONE_ACCELERATOR_SESSION_FAILED (9) – There was a failure setting up the Intel® QAT accelerator. It is recommended to check the error log for the availability of the hardware, and the Intel® QAT driver and library versions. It is recommended to verify that the drivers were successfully installed. For support resources, see Support. NONE_ACCELERATOR_LIBRARY_NOT_FOUND (10) – The qatzip.dll or isa-l.dll libraries are not available. It is recommended to verify that the drivers were successfully installed. For support resources, see Support. SOFTWARE_MODE_NON_ENTERPRISE_SKU (11) – SQL Server 2022 (16.x) instance with the Intel® QAT enabled is using software mode because of the current edition (SKU). SOFTWARE_MODE_ACCELERATOR_HARDWARE_NOT_FOUND (12) – The SQL Server instance with hardware offloading and accelerator enabled is using software mode due to the hardware device not being available, due to device or driver failure. For support resources, see Support. SOFTWARE_MODE_SOFTWARE_FORCE_OVERRIDE (13) – User forced software mode using ALTER SERVER CONFIGURATION SET HARDWARE_OFFLOAD = ON (ACCELERATOR = QAT, MODE = SOFTWARE) HARDWARE_MODE_ENTERPRISE_SKU (14) – The SQL Server 2022 (16.x) instance with hardware offload and accelerator enabled is using hardware support, with software fallback. Hardware offloading is supported for any accelerator in SQL Server 2022 (16.x) and later. |
accelerator_hardware_detected | tinyint | 1 : Hardware is detected. 0 : Hardware is not detected. |
accelerator_library_version | nvarchar(60) | The library version for the accelerator. |
accelerator_driver_version | nvarchar(60) | The driver version for the accelerator. |
Permissions
Requires VIEW PERFORMANCE STATE
permission on the server.
Remarks
The sys.dm_server_accelerator_status
lists available accelerators for your version of SQL Server. A row for Intel® QuickAssist Technology (QAT) for backup/restore compression appears by default starting with SQL Server 2022 (16.x), even if the QAT hardware is not present and the QAT driver is not installed. Other hardware or software accelerators may be added in the future cumulative updates and major releases of SQL Server.
Support
For documentation and support for mode_reason_desc values, see Intel® QuickAssist Technologies (QAT).