This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
DoubleA
Level 2
‎Sep 20, 2012 03:17 PM

Large SQL install

I have an issue with a large data script I am trying to insert with my install. I have the file is about 10MB. After some testing I found that if I broke it into smaller segments the installer would load the smaller 1mb files. However I am still running into the issue where that install hangs after about the 5 script.

Anyone have any ideas the best way to run such a large script?

Cheers!
Labels (1)
Labels
0 Kudos
(1) Reply
DoubleA
Level 2
‎Sep 26, 2012 09:54 AM

I found the answer to my issue i had to turn on verbose logging. Once I did that I found that I was running out of memory.

I increased the maximum heap size and added -Xss5124k in the additional Arguments.

This seemed to fix the issue.
0 Kudos