Rife with Out of Memory Exceptions.
So, I install the tool to use with a real-world database of 1GB. And all I get are Out-of-Memory exceptions when trying to add data. Or even just run the tool. This is one of the worst software experiences that I've ever had!
Did I just get a buggy version? 3.0.13.4214
-
Lenny Smith
commented
I am running into this problem on my machine. My machine is a pretty good one, and I have around 11 GB free when I try to commit.
And I wouldn't think that the RAM itself is the issue, as the process would just begin swapping pages to disk when RAM isn't available. An out of memory issue points to having some runaway allocations that eat up all of the 32-bit virtual address space.
A production tool shouldn't be doing this on almost every button click.
-
paul
commented
have you looked at your dev machine setup ?
how much free ram to start with ?
add ram to your machine perhaps ? -
lance
commented
Or when exporting the data, the tool breaks it up into manageable batches that it can process.
-
lance
commented
Or alter the tool so that it's not a plugin for SSMS? So it's not limited to 32bit.
-
lance
commented
Maybe swap to disk when memory pressure is detected? It's slow, but reliable.