FIX: FileTable directory stops responding when you create multiple files concurrently in SQL Server 2014 or 2016

Velja za: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise

Symptoms


When you concurrently create multiple files in a FileTable directory in an instance of Microsoft SQL Server 2014 or 2016, a deadlock may occur internally in the SQL Server Engine and all the subsequent requests to FileTable directories may not be responded.

Resolution


Workaround


To work around this issue, restart your instance of SQL Server 2014 or 2016.

References


Learn about the terminology that Microsoft uses to describe software updates.