Skip to content

Commit 3745f48

Browse files
v-stsavellv-stsavell
authored
Merge pull request #23752 from MikeRayMSFT/20220816-release-dallas-intel-qat
Integrated acceleration
2 parents b218fed + 57287c7 commit 3745f48

13 files changed

Lines changed: 536 additions & 84 deletions

‎docs/database-engine/configure-windows/hardware-offload-enable-configuration-option.md‎

Lines changed: 51 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,51 @@
1+
---
2+
title: "Hardware offload enable server configuration option | Microsoft Docs"
3+
description: 'Learn about the "hardware offload enabled" option. '
4+
ms.custom: ""
5+
ms.date: 08/17/2022
6+
ms.prod: sql
7+
dev_langs:
8+
- "TSQL"
9+
helpviewer_keywords:
10+
- "hardware offload enable"
11+
- "HARDWARE_OFFLOAD"
12+
ms.reviewer: david.pless, wiassaf
13+
ms.technology: configuration
14+
ms.topic: conceptual
15+
author: MikeRayMSFT
16+
ms.author: mikeray
17+
18+
---
19+
# Hardware offload enabled configuration option
20+
21+
[!INCLUDE [sqlserver2022](../../includes/applies-to-version/sqlserver2022.md)]
22+
23+
The `hardware offload enabled` configuration option allows integrated offloading and acceleration with validated solutions from partners. For more information, see [Integrated offloading and acceleration](../../relational-databases/integrated-acceleration/overview.md).
24+
25+
This is an advanced option.
26+
27+
Changing option requires a restart.
28+
29+
## Example
30+
31+
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:
32+
33+
```sql
34+
sp_configure 'show advanced options', 1
35+
GO
36+
RECONFIGURE
37+
GO
38+
sp_configure 'hardware offload enabled', 1
39+
GO
40+
RECONFIGURE
41+
GO
42+
```
43+
44+
> [!NOTE]
45+
> If `hardware offload enabled` is disabled (`0`), all offloading and acceleration solutions are disabled.
46+
47+
## Next steps
48+
49+
- [sys.dm_server_accelerator_status](../../relational-databases/system-dynamic-management-views/sys-dm-server-accelerator-status-transact-sql.md)
50+
- [Server configuration options (SQL Server)](../../database-engine/configure-windows/server-configuration-options-sql-server.md)
51+
- [ALTER SERVER CONFIGURATION (Transact-SQL)](../../t-sql/statements/alter-server-configuration-transact-sql.md)

‎docs/relational-databases/backup-restore/backup-compression-sql-server.md‎

Lines changed: 20 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
11
---
2-
title: "Backup Compression (SQL Server) | Microsoft Docs"
2+
title: "Backup compression (SQL Server) | Microsoft Docs"
33
description: Learn about compression of SQL Server backups, including restrictions, performance trade-offs, Configuring backup compression, and the compression ratio.
44
ms.custom: ""
5-
ms.date: 07/25/2022
5+
ms.date: 08/18/2022
66
ms.prod: sql
77
ms.prod_service: backup-restore
88
ms.reviewer: ""
@@ -15,23 +15,25 @@ helpviewer_keywords:
1515
- "backups [SQL Server], compression"
1616
- "backing up [SQL Server], backup compression"
1717
- "backup compression [SQL Server]"
18-
ms.assetid: 05bc9c4f-3947-4dd4-b823-db77519bd4d2
1918
author: MashaMSFT
2019
ms.author: mathoma
2120
---
22-
# Backup Compression (SQL Server)
23-
[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
24-
This topic describes the compression of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] backups, including restrictions, performance trade-off of compressing backups, the configuration of backup compression, and the compression ratio. Backup compression is supported on [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] editions: Enterprise, Standard, and Developer. Every edition of [!INCLUDE[ssKatmai](../../includes/sskatmai-md.md)] and later can restore a compressed backup.
21+
# Backup compression (SQL Server)
22+
23+
[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
24+
25+
This article describes the compression of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] backups, including restrictions, performance trade-off of compressing backups, the configuration of backup compression, and the compression ratio. Backup compression is supported on [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] editions: Enterprise, Standard, and Developer. Every edition of [!INCLUDE[ssKatmai](../../includes/sskatmai-md.md)] and later can restore a compressed backup.
2526

2627

2728
## <a name="Benefits"></a> Benefits
2829

2930
- Because a compressed backup is smaller than an uncompressed backup of the same data, compressing a backup typically requires less device I/O and therefore usually increases backup speed significantly.
3031

31-
For more information, see [Performance Impact of Compressing Backups](#PerfImpact), later in this topic.
32+
For more information, see [Performance Impact of Compressing Backups](#PerfImpact), later in this article.
3233

3334

3435
## <a name="Restrictions"></a> Restrictions
36+
3537
The following restrictions apply to compressed backups:
3638

3739
- Compressed and uncompressed backups cannot co-exist in a media set.
@@ -41,10 +43,13 @@ ms.author: mathoma
4143
- NTbackups cannot share a tape with compressed [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] backups.
4244

4345

44-
## <a name="PerfImpact"></a> Performance Impact of Compressing Backups
45-
By default, compression significantly increases CPU usage, and the additional CPU consumed by the compression process might adversely impact concurrent operations. Therefore, you might want to create low-priority compressed backups in a session whose CPU usage is limited by[Resource Governor](../../relational-databases/resource-governor/resource-governor.md). For more information, see [Use Resource Governor to Limit CPU Usage by Backup Compression &#40;Transact-SQL&#41;](../../relational-databases/backup-restore/use-resource-governor-to-limit-cpu-usage-by-backup-compression-transact-sql.md).
46+
## <a name="PerfImpact"></a> Performance impact of compressing backups
47+
48+
By default, compression significantly increases CPU usage, and the additional CPU consumed by the compression process might adversely impact concurrent operations. Therefore, you might want to create low-priority compressed backups in a session whose CPU usage is limited by [Resource Governor](../../relational-databases/resource-governor/resource-governor.md). For more information, see [Use Resource Governor to Limit CPU Usage by Backup Compression &#40;Transact-SQL&#41;](../../relational-databases/backup-restore/use-resource-governor-to-limit-cpu-usage-by-backup-compression-transact-sql.md).
49+
50+
Beginning with [!INCLUDE [sssql22-md](../../includes/sssql22-md.md)], you can use [Integrated offloading & acceleration](../integrated-acceleration/overview.md) to compress backups and offload the CPU resources for the backup.
4651

47-
To obtain a good picture of your backup I/O performance, you can isolate the backup I/O to or from devices by evaluating the following sorts of performance counters:
52+
To obtain a good picture of your backup I/O performance, you can isolate the backup I/O to or from devices by evaluating the following sorts of performance counters:
4853

4954
- Windows I/O performance counters, such as the physical-disk counters
5055

@@ -55,7 +60,7 @@ ms.author: mathoma
5560
For information about Windows counters, see Windows help. For information about how to work with SQL Server counters, see [Use SQL Server Objects](../../relational-databases/performance-monitor/use-sql-server-objects.md).
5661

5762

58-
## <a name="CompressionRatio"></a> Calculate the Compression Ratio of a Compressed Backup
63+
## <a name="CompressionRatio"></a> Calculate the compression ratio of a compressed backup
5964
To calculate the compression ratio of a backup, use the values for the backup in the **backup_size** and **compressed_backup_size** columns of the [backupset](../../relational-databases/system-tables/backupset-transact-sql.md) history table, as follows:
6065

6166
**backup_size**:**compressed_backup_size**
@@ -94,12 +99,13 @@ Starting with [!INCLUDE[sql-server-2019](../../includes/sssql19-md.md)] CU5, set
9499

95100
For more information, see [BACKUP (Transact-SQL)](../../t-sql/statements/backup-transact-sql.md).
96101

97-
## <a name="Allocation"></a> Allocation of Space for the Backup File
102+
## <a name="Allocation"></a> Allocation of space for the backup file
103+
98104
For compressed backups, the size of the final backup file depends on how compressible the data is, and this is unknown before the backup operation finishes. Therefore, by default, when backing up a database using compression, the Database Engine uses a pre-allocation algorithm for the backup file. This algorithm pre-allocates a predefined percentage of the size of the database for the backup file. If more space is needed during the backup operation, the Database Engine grows the file. If the final size is less than the allocated space, at the end of the backup operation, the Database Engine shrinks the file to the actual final size of the backup.
99105

100106
To allow the backup file to grow only as needed to reach its final size, use trace flag 3042. Trace flag 3042 causes the backup operation to bypass the default backup compression pre-allocation algorithm. This trace flag is useful if you need to save on space by allocating only the actual size required for the compressed backup. However, using this trace flag might cause a slight performance penalty (a possible increase in the duration of the backup operation).
101107

102-
## <a name="RelatedTasks"></a> Related Tasks
108+
## <a name="RelatedTasks"></a> Related tasks
103109

104110
- [Configure Backup Compression &#40;SQL Server&#41;](../../relational-databases/backup-restore/configure-backup-compression-sql-server.md)
105111

@@ -111,7 +117,7 @@ For more information, see [BACKUP (Transact-SQL)](../../t-sql/statements/backup-
111117

112118
- [DBCC TRACEOFF &#40;Transact-SQL&#41;](../../t-sql/database-console-commands/dbcc-traceoff-transact-sql.md)
113119

114-
## See Also
120+
## Next steps
115121
[Backup Overview &#40;SQL Server&#41;](../../relational-databases/backup-restore/backup-overview-sql-server.md)
116122
[Trace Flags &#40;Transact-SQL&#41;](../../t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql.md)
117123

‎docs/relational-databases/backup-restore/configure-backup-compression-sql-server.md‎

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -15,6 +15,10 @@ ms.author: mathoma
1515
# Configure Backup Compression (SQL Server)
1616
[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
1717
At installation, backup compression is off by default. The default behavior for backup compression is defined by the **backup compression default** Option server-level configuration option. However, you can override the server-level default when creating a single backup or scheduling a series of routine backups. To change the server-level default, see [View or Configure the backup compression default Server Configuration Option](../../database-engine/configure-windows/view-or-configure-the-backup-compression-default-server-configuration-option.md).
18+
19+
## Use integrated acceleration and offloading
20+
21+
Beginning with [!INCLUDE [sssql22-md](../../includes/sssql22-md.md)], use [Integrated offloading and acceleration](../integrated-acceleration/overview.md) to compress backups with Intel QuickAssist Technology.
1822

1923
## Override the Backup Compression Default
2024
You can change the backup compression behavior for an individual backup, backup job, or log shipping configuration.

0 commit comments

Comments
 (0)