FIX: I/O error on a BPE file causes buffer time-out in SQL Server

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Symptoms


Assume that you have an instance of Microsoft SQL Server 2014, 2016 or 2017 that has buffer pool extension (BPE) enabled. If you experience an I/O error that occurs on the BPE file, BPE may be disabled, and a buffer time-out error that resembles the following is logged:

When this issue occurs, some orphaned buffer latches remain, and any operation such as DBCC CHECKDB, CHECKPOINTING, or BACKUP LOG fail.

Note If you update to Cumulative Update 1 for SQL Server 2014 Service Pack 1, the error still cannot be resolved.

Resolution


Cumulative update information:

This issue is fixed in the following updates for SQL Server:

       Cumulative Update 14 for SQL Server 2017

       Cumulative Update 5 for SQL Server 2016 Service Pack2

       Cumulative Update 1 for SQL Server 2014 Service Pack 3

       Cumulative Update 15 for SQL Server 2014 Service Pack 2

On-demand hotfix information:

This issue is fixed in the following on-demand hotfix update for SQL Server:

       On-demand hotfix update for SQL Server 2016 SP2 CU4  

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 Microsoft uses to describe software updates.