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.