แก้ไข

แชร์ผ่าน


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).

Next steps