Home Dashboard Directory Help

APPCRASH DTAEngine.exe Exception Code: c0000374 by DavGarcia



Sign in
to vote
Type: Bug
ID: 799274
Opened: 8/30/2013 10:44:42 AM
Access Restriction: Public
User(s) can reproduce this bug


I'm running SQL Server 2012 SP1 CU4

@@version is
Microsoft SQL Server 2012 (SP1) - 11.0.3368.0 (X64)
    May 22 2013 17:10:44
    Copyright (c) Microsoft Corporation
    Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)

I'm trying to run the Database Tuning Adviser, but after a while I get the following error:

Problem signature:
Problem Event Name:    APPCRASH
Application Name:    DTAEngine.exe
Application Version:    2011.110.2100.60
Application Timestamp:    4f35e343
Fault Module Name:    StackHash_bfc7
Fault Module Version:    6.0.6002.18881
Fault Module Timestamp:    51da3e00
Exception Code:    c0000374
Exception Offset:    000abc4f
OS Version:    6.0.6002.
Locale ID:    1033
Additional Information 1:    bfc7
Additional Information 2:    e6ce123640351117c1530cd9240df39a
Additional Information 3:    308a
Additional Information 4:    7d29f2a1529fa1de291827b76f892d65

Read our privacy statement:

I've tried this four times, and all failed with the same error above. I'm creating SQL Profile logs on disk using the Tuning template. I'm filtering so that only my target database's transactions are saved. The files are anywhere from 300MB to 1GB.

Just out of curiosity I captured a few transactions which came out to 5MB. That actually ran in the DTA without producing an error message. So it isn't something that happens every time (at least for a very small dataset.) But is happening consistently with my larger data samples. I've looking online, and in this knowledge base, but haven't been able to find a solution.
Sign in to post a comment.
Posted by Microsoft on 12/3/2013 at 3:47 PM

As mentioned, we have been unable to reproduce. Without any file, we will have to resolve the item.
Posted by Microsoft on 11/18/2013 at 3:44 PM
Hello Dav. We will be unable to reproduce this behavior without one of your trace files. Please let us know if you can provide us with your data. Otherwise, we'll have to close "no repro."
Posted by DavGarcia on 8/31/2013 at 8:32 AM
I tried using a rolling trace file, set to 50MB. After 5 were saved I tried running DTA, but it still is crashing in the same manner.
Sign in to post a workaround.