Database Engine Tuning Advisor crash with File workload - by emazv

Status : 

  Duplicate<br /><br />
		This item appears to be a duplicate of another existing Connect or internal item.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


4
0
Sign in
to vote
ID 808316 Comments
Status Closed Workarounds
Type Bug Repros 3
Opened 11/12/2013 12:54:55 AM
Access Restriction Public

Description

I am using Database Engine Tuning Advisor on SQL Server 2012. 
When I select the File workload option, it crashes with the message "Tuning process exited unexpectedly. (DTAEngine)". 
My account is in the sysadmin role.
Sql Server version is 11.0.3373
Sign in to post a comment.
Posted by Dudu Lins on 11/18/2014 at 8:42 PM
Same problem using SQL Server 2012 with Service Pack 2 and Latest Cumulative Updates. Trace workload was created using Tuning template.

Product: Microsoft SQL Server Enterprise: Core-based Licensing (64-bit)
Operating System: Microsoft Windows NT 6.1 (7601)
Platform: NT x64
Version: 11.0.5548.0
Memory: 131037 (MB)
Processors: 40

Problem signature:
Problem Event Name:    APPCRASH
Application Name:    DTAEngine.exe
Application Version:    2011.110.5058.0
Application Timestamp:    53740751
Fault Module Name:    StackHash_ef2e
Fault Module Version:    6.1.7601.18247
Fault Module Timestamp:    521ea8e7
Exception Code:    c0000374
Exception Offset:    000ce753
OS Version:    6.1.7601.2.1.0.274.10
Locale ID:    1046
Additional Information 1:    ef2e
Additional Information 2:    ef2eb95bdeeea2d265a1948c0eb31a75
Additional Information 3:    8702
Additional Information 4:    87025d8b4b3d04a1aca32cf649da9253

Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt
Posted by Sergio526 on 7/4/2014 at 4:51 AM
I'm having the same problem, even after applying Service Pack 2!

SQL Version: 11.0.5058
DTA Version: 11.0.2100.60
Posted by Microsoft on 12/13/2013 at 9:34 AM
Hello emazv. Thank you for your feedback. We are already aware of and tracking this item itnernally and will follow-up there.
Posted by hyomer.alex on 11/27/2013 at 10:37 PM
We have the same problem on different instances.
SQL Server version is the same, connection by sysadmin. Tuning options are default.
Trace was collected using "Tuning" template in SQL Server profiler.
Minidump was created twice (from first and second attempts on different servers)