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

    Question

  • 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?

    Tuesday, August 10, 2010 6:45 PM

All replies

  • 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 9:33 PM
    Moderator
  • 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

    Tuesday, August 10, 2010 11:08 PM
  • 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
    Wednesday, August 11, 2010 5:02 AM
    Moderator
  • 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

    Thursday, February 23, 2012 10:04 PM