An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown

• coolchaitu

  SSChampion

  Points: 10315

  More actions

  April 27, 2010 at 9:57 pm

  #146756

  Hi,

  We have developed import/export script and generated high volume of test data to conduct performance testing. There is a code that loads 18 million rows each on 2 tables and 300,000 rows on another table. I executed this code and the it ran for a very long time(>20 minutes) and returned the following error:

  An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown

  Can anyone help me out with this.

  Thanks,

  Kiran

• Grant Fritchey

  SSC Guru

  Points: 397721

  More actions

  April 28, 2010 at 6:07 am

  #1158805

  Cross posting just confuses things. Please reply here: http://qa.sqlservercentral.com/Forums/Topic911607-145-1.aspx

  ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software