Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
DTA: "Tuning process exited unexpectedly" during Generating Reports agaist partitioned table

Unanswered DTA: "Tuning process exited unexpectedly" during Generating Reports agaist partitioned table

  • Tuesday, August 10, 2010 6:45 PM
     
     
    Sign In to Vote
    0

    When I run DTA with a very simple SELECT script agaist a partitioned table, I got "Tuning process exited unexpectedly" during Generating Reports. I tried similar script agaist regular table (no partion on the table) work just fine.

    Any ideas?

     

All Replies

  • Tuesday, August 10, 2010 9:33 PM
    Moderator
     
     
    Sign In to Vote
    0

    whats the SQL version? SQL 2005 or SQL 2008? Please run @@version and post the output.

    There should be a dump genereated in \90\Shared\ErrorDumps folder.

     

    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
     
  • Tuesday, August 10, 2010 11:08 PM
     
     
    Sign In to Vote
    0

    Thank you for reply.This is SQL 2008 R2 (RTM) - 10.50.1600.

    I did not find any dump in  \90\Shared\ErrorDumps  or  \100\Shared\ErrorDumps

     
  • Wednesday, August 11, 2010 5:02 AM
    Moderator
     
     
    Sign In to Vote
    0

    Could you please check for any error in the same time in SQL ErrorLog? Like Access_violation? If yes, then dump would go to %ProgramFiles%\Microsoft SQL Server\MSSQL.<InstanceID>\MSSQL\LOG

     

    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
     
  • Thursday, February 23, 2012 10:04 PM
     
     
    Sign In to Vote
    0

    Hi Balmukund,

    I am experiencing same problem. I am using "Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0"  and I can see errordump folder which is empty. I did check online and it says I have to download cumulative hotfix package but, that is for sql server 2005 which does not support sql server 2008r2. What can be the solution?

    Thanks