September 5, 2012 at 2:12 pm
I am trying to run the Database engine tuning advisor but when I try and run it I get an error that it has stopped responding.
I have noticed that I have an occurance of DTASHELL.EXE running for each of the failures.
Is it possible to terminate those processes and try again? I now have 3 of them running.
Thanks
Bob
September 5, 2012 at 6:48 pm
bob.lawson (9/5/2012)
I am trying to run the Database engine tuning advisor but when I try and run it I get an error that it has stopped responding.I have noticed that I have an occurance of DTASHELL.EXE running for each of the failures.
Is it possible to terminate those processes and try again? I now have 3 of them running.
I expect that you've already killed those processes but if you run it again you might want to check the target SQL Server and the DTASHELL.EXE process to see if they are busy doing something. I presume that you're investigating a performance issue so there's a good chance that the utility is stuck on a query. If I remember correctly, DTA needs to actually run the queries to get the execution plan and compare it to the actual performance of the queries. Bad queries could make this take a while.
[font="Tahoma"]Bryant E. Byrd, BSSE MCDBA MCAD[/font]
Business Intelligence Administrator
MSBI Administration Blog
September 6, 2012 at 7:37 am
The issue seems to be around two clustered indexes I created yesterday. I ran it yesterday and the top result was to create clustered indexes for two of the tables. I ran it today telling it to ignore the clustered indexes and it is running again.
Killing the processes DTASHELL.EXE seems to not have had a negative effect.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply