Red Gate forums :: View topic - Exception of type 'System.OutOfMemoryException' was thrown.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Multi Script 1
SQL Multi Script 1 forum

Exception of type 'System.OutOfMemoryException' was thrown.

Search in SQL Multi Script 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
quinnpumps



Joined: 07 Oct 2008
Posts: 1

PostPosted: Tue Oct 07, 2008 5:54 pm    Post subject: Exception of type 'System.OutOfMemoryException' was thrown. Reply with quote

Script is 25.5 GB. Using Vista Business on Quad Core 2.33GHz processor, 2GB of RAM. This error occurs when attempting to open the script.
Back to top
View user's profile Send private message
Robert



Joined: 30 Oct 2006
Posts: 428
Location: Cambridge, UK

PostPosted: Thu Oct 09, 2008 5:04 pm    Post subject: Reply with quote

Assuming "GB" isn't a typo...!

I'm afraid SQL Multi Script needs to load the entire script into memory before executing it. On a 32-bit machine, each process is limited to 2GB of memory space, even if the system has more physical memory installed. [Edit: I've just checked and SQL Multi Script is currently set to run as a 32-bit process, even on a 64-bit operating system, so upgrading to Vista x64 won't help here]

We tested up to about 500MB scripts, if I remember correctly, but that's a couple of orders of magnitude smaller than what you're attempting.

Out of interest, what are you trying to do that results in such a gigantic script? Smile

Thanks,
Robert
_________________
Robert Chipperfield
Developer, Red Gate Software Ltd
Back to top
View user's profile Send private message MSN Messenger
richardr



Joined: 14 May 2010
Posts: 2

PostPosted: Fri May 14, 2010 9:12 pm    Post subject: Reply with quote

I am curious about this. I was running a script against 99 databases and failed on the "out of memory" error. The script is only about 3.5mb large and has about 17k lines of code.
Is there a limit to the lines of code? The machine that I used has 2GB of RAM and enough processor power to run these scripts.
Here is the context of the error:

SQL Multi Script has encountered a problem. Details are as follows:

Exception of type 'System.OutOfMemoryException' was thrown.

at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at J.b(Object , DataTable )
at RedGate.SQLMultiScript.Engine.Engine.b(DataTable )
at RedGate.SQLMultiScript.Engine.Engine.b(Object )
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart(Object obj)

Thanks,
Richard
Back to top
View user's profile Send private message
richardr



Joined: 14 May 2010
Posts: 2

PostPosted: Tue May 18, 2010 5:50 pm    Post subject: Reply with quote

are these forums still monitored?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Wed May 19, 2010 11:21 am    Post subject: Reply with quote

Yes, the forums are moderated, but I assume that the person who replied to the topic would answer any further posts.

I don't know anything about this issue, so maybe it would be best to contact support@red-gate.com - at any rate I don't think this topic is simple enough to use the forum as a support channel.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group