SQL 2012 DTA Engine Crashes on Windows 8

Question:

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.

Solution:

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

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

*