FIX: DTA utility crashes with an access violation when you use user-defined function in SQL Server

Gilt für: SQL Server 2008 R2 Service Pack 2SQL Server 2008 R2 DeveloperSQL Server 2008 R2 Enterprise

Symptoms


Consider the following scenario:
  • You have Microsoft SQL Server 2008 R2, SQL Server 2012, or SQL Server 2014 installed on a computer.
  • You use DTA utility (Database Engine Tuning Advisor) to optimize against some workload.
  • The workload being analyzed by DTA includes the execution(s) of one or more user-defined functions (UDF).
In this scenario, DTA utility crashes with an access violation.

Cause


The issue occurs because of a defect in SQL Server DTA utility.

Resolution


The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 1 for SQL Server 2012 SP2

Cumulative Update 2 for SQL Server 2014

Cumulative Update 10 for SQL Server 2012 SP1

Cumulative Update 12 for SQL Server 2008 R2 SP2

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.