Symptoms
Assume that you are using Microsoft SQL Server. You may see slow performance when restoring a compressed backup of an SQL Server database in any of the following scenarios:
- Restoring to a disk with 4K sector size.
- Restoring to a SQL Server hosted on an Azure Infrastructure-as-a-Service Virtual Machines (IaaS VM) (Azure IaaS VM disks will have a 4K sector size).
- Restoring to a 512 sector size disk with Trace Flag (TF) 1800 enabled.
Resolution
This issue is fixed in the following cumulative updates for SQL Server:
Cumulative update 9 for SQL Server 2016 SP1
Cumulative Update 1 for SQL Server 2016 SP2
Cumulative Update 7 for SQL Server 2017
Cumulative Update 12 for SQL Server 2014 SP2
Service Pack information for SQL Server:
This issue is fixed in the following service pack for SQL Server:
Service Pack 3 for SQL Server 2014
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the terminology that Microsoft uses to describe software updates.