FIX: Slow restore performance when restoring a compressed backup on a disk with 4K sector size in SQL Server

Applies to: Microsoft SQL Server 2016 Service Pack 1SQL Server 2016 DeveloperSQL Server 2016 Enterprise More

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:

  1. Restoring to a disk with 4K sector size.
  2. 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).
  3. 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.