February 14, 2009 at 12:29 pm
An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown.
I was running a query which pulls 10million records, after running for 1 hour it gave me this error. how shud i troubleshoot this, what is the cause?
February 14, 2009 at 1:03 pm
you could maybe limit the query
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2009 at 6:51 am
what do u mean by limit the query. do you want the query to run in batches for select statement.
February 15, 2009 at 7:11 am
Where are you gettings those records from?
What do you intend to do with them?
I'm guessing here that this is some sort of dataload since showing 10M records to the users is quite useless (from my humble experience).
February 15, 2009 at 2:25 pm
Ninja's_RGR'us (2/15/2009)
since showing 10M records to the users is quite useless (from my humble experience).
my thoughts exactly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2009 at 2:42 pm
Hey Darth. stop reading my freaking mind!!!
or is it the other way around :D.
February 16, 2009 at 6:54 am
Ninja's_RGR'us (2/15/2009)
Hey Darth. stop reading my freaking mind!!!or is it the other way around :D.
i find your lack of faith most disturbing ....... LOL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 16, 2009 at 7:33 am
You'll find that you can't argue with yourself :P.
February 16, 2009 at 9:19 am
What are you doing with the 10 million records? Aggregating? Feeding into another application? The intended use of the records may provide some assistance as to how to improve performance.
Also, how is the table indexed? Have you run your query through DTA to see what SQL recommends with regard to indices associated with the query?
Also, how much RAM does the system running the query have? How many procs/cores? It could be that you need to turn on AWE, adjust your sql memory to 3 gig and increase your SQL Server pool size using the -g switch.
If you actually do need the 10 million rows, there may be ways to optimize the query and/or system to support that.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply