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.
This issue is fixed in the following cumulative updates for SQL Server:
Service Pack information for SQL Server:
This issue is fixed in the following service pack for SQL Server:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.