SQL 2012 DTA Engine Crashes on Windows 8


Some time back I wrote an article on the new feature that’s added to SQL Server 2012 DTA (database tuning advisor). I have installed SQL Server 2012 on Windows 8 operating system. When I started testing plan cache analysis using DTA , it crashes abruptly with the error message below

Level    Date and Time    Source    Event ID    Task Category
Error    11/21/2012 6:15:55 PM    Application Error    1000    (100)    “Faulting application name: DTAEngine.exe, version: 2011.110.2100.60, time stamp: 0x4f35e343
Faulting module name: ntdll.dll, version: 6.2.9200.16420, time stamp: 0x505aaa82
Exception code: 0xc0000374
Fault offset: 0x000da94f
Faulting process id: 0xb40
Faulting application start time: 0x01cdc7e62330b22f
Faulting application path: C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\DTAEngine.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: 638c9ca1-33d9-11e2-be71-001a80264e7e
Faulting package full name:
Faulting package-relative application ID: ”

I have another system with Windows 7 and I tested it there, it worked perfectly fine.  So I started searching in google to find out a solution, I got the link from Microsoft Connect which states that some users faced similar issue but that’s been rectified in the RTM release but I already have the RTM version.


If you are facing similar issue in Windows 8 then you have apply service pack 1 for SQL Server 2012 which is released a month ago. I have installed SP1 and the issue is fixed now. I’m successfully able to run plan cache analysis in SQL 2012 DTA.

Leave a Reply

Leave a comment

Your email address will not be published. Required fields are marked *



Related Posts

What's new in DTA - SQL Server 2012
DTA stands for Database Tuning Advisor which has introduced from SQL Server 2005. This utility helps the end user to tune their query and give th...
Script to get data file usage and autogrowth details
I've wrote this script to get data file allocated and used space. In addition to this I've also added auto growth setting details for the data fi...
Contained Database - SQL Server 2012
In SQL Server Denali we have new feature called contained database that will let you move your database easily. Understood? Whatever I said is a ...
powered by RelatedPosts