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

• coolchaitu

  SSChampion

  Points: 10334

  More actions

  April 27, 2010 at 9:57 pm

  #220931

  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: 398908

  More actions

  April 28, 2010 at 6:02 am

  #1158799

  Please don't cross-post. It just diffuses the conversation and duplicates efforts.

  Reply to this question here: http://www.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 Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning