FIX: Deadlock occurs when multiple PREDICT T-SQL functions run concurrently in SQL Server 2017

Applies to: SQL Server 2017 Developer on WindowsSQL Server 2017 Enterprise on WindowsSQL Server 2017 Enterprise Core on Windows

Symptoms


Assume that you use the new PREDICT Transact-SQL function that's introduced in SQL Server 2017 on Windows. When you concurrently execute multiple PREDICT functions, a deadlock might occur.

Resolution


This issue is fixed in the following cumulative update for SQL Server:

       Cumulative Update 2 for SQL Server 2017

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.