April 27, 2010 at 9:57 pm
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
April 28, 2010 at 6:03 am
You asked this same question over at ask.sqlservercentral.com.
Over there several people asked you to specify some details. The same questions still apply:
You'll need to provide more information to get a sensible response on this one... – Matt Whitfield? 6 hours ago
1
I agree, you'll only get responses along the lines of 'you need a bigger server' until we get some details – Fatherjack 4 hours ago
At a wild stab in the dark, I'm going to say this is a client side SSMS exception which could be solved with SET NOCOUNT ON, or by returning less result sets to the client... – Matt Whitfield? 1 hour ago
How was the script called? SQLCMD? Was the error registered on the server or on the client? Was a client involved at all? Too many variables to try to provide an answer that would be remotely meaningful. – Grant Fritchey 43 mins ago
"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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply