February 2, 2011 at 5:39 am
Hi,
Am getting this error "System.OutOfMemoryException" when am trying to save my package. For this, as per this http://www.sqlservercentral.com/Forums/Topic468837-5-1.aspx discussion, i wanted to set MemToLeave to 512MB and to change the -g startup parameter. I don't know how to set this and i don't know the command also. Can any of you please explain this from basic. And suggest me is there any other way to solve this issue without splitting up the package.
Thanks in advance.
Regards,
Dharani
February 3, 2011 at 9:38 am
The startup options are set in the services applet for the service
The settings are here: http://msdn.microsoft.com/en-us/library/ms190737.aspx
February 3, 2011 at 8:02 pm
I would be wary about changing memtoleave. I suspect that the system.outofmemory exception you are getting is more likely to be a problem that visual studio / BIDS is experiencing. I certaining have experienced outofmemory exceptions in visual studio. Normally these "go away" when visual studio is restarted.
By increasing memtoleave, you are also reducing the memory available to SQL Server for data etc which may be detrimential to the performance of SQL Server.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply