Home Dashboard Directory Help
Search

Database Engine Tuning Advisor crash with Plan Cache workload by Kevin Feit, Slalom Consulting


Status: 

Closed
 as Duplicate Help for as Duplicate


4
0
Sign in
to vote
Type: Bug
ID: 787217
Opened: 5/19/2013 7:48:15 AM
Access Restriction: Public
0
Workaround(s)
view
4
User(s) can reproduce this bug

Description

I am using Database Engine Tuning Advisor on SQL Server 2012. When I select the Plan Cache workload option, it crashes with the message "Tuning process exited unexpectedly. (DTAEngine)". My account is in the sysadmin role.

Dump Summary
------------
Dump File: DTAEngine90_20130518170817_0.mdmp : C:\Program Files (x86)\Microsoft SQL Server\110\Shared\ErrorDumps\DTAEngine90_20130518170817_0.mdmp
Last Write Time: 5/18/2013 5:08:19 PM
Process Name: DTAEngine.exe : C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\DTAEngine.exe
Process Architecture: x86
Exception Code: 0xC0000005
Exception Information: The thread tried to read from or write to a virtual address for which it does not have the appropriate access.
Heap Information: Not Present

System Information
------------------
OS Version: 6.1.7601
CLR Version(s):

Modules
-------
Module Name Module Path Module Version
----------- ----------- --------------
DTAEngine.exe C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\DTAEngine.exe 2011.110.2100.60

Client is running VMware, but I have had same issue running on the SQL Server directly, which is a physical server.
Details
Sign in to post a comment.
Posted by Jbirg on 1/8/2014 at 1:40 PM
I am experiencing this same issue and installed all updates up to CU7 on SQL server 2012. my only difference from the original post is that i am running on a Azure Virtual machine and it occurs for other workloads - file, or database table.

It looks like kb2862241 was supposed to address this issue.

Any updates to this issue?
Posted by Microsoft on 6/11/2013 at 1:24 PM
This issue was fixed and will be available in the next major SQL Server release. If you'd like to port this fix into CU for SQL Server 2012 - please file an RFC request.

Thank you,
Vladimir Svidersky [MSFT SQL SERVER]
Posted by Kevin Feit, Slalom Consulting on 5/21/2013 at 8:04 PM
Vladimir,

My SQL Server collation is SQL_Latin1_General_CP1_CI_AS.
Yes, the MSDB database already has the DTA_* tables and stored procedures.

Thanks,
Kevin
Posted by Microsoft on 5/21/2013 at 1:51 PM
Kevin,

Can you please provide two additional pieces of information for me to better understand your situation. What's you SQL Server collation? (open properties for SQL Server and copy-paste Server Collation line). And in your [msdb] on this server do you already have DTA_* tables created and sp_DTA_* stored procedures? (Just open list of tables and stored procedures for msdb).

Thank you,
Vladimir Svidersky [MSFT SQL SERVER]
Posted by Microsoft on 5/20/2013 at 12:53 PM
Thank you for reporting this issue - we are investigating and will update you when we have more information.

Thanks,

Alex Grach [MSFT SQL SERVER]
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
DTAEngine90_20130518170817_0mdmp.txt 5/19/2013 283 KB
SQLDUMPER_ERRORLOG.log 5/19/2013 12 KB