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.