Executive Summary: Pelaa-Sins
You're into a game of Sins that has been running fine for an extended period (minutes, hours), and it suddenly crashes with a minidump. Boom!
There are many reasons why this can happen. This "mod" (if you can call it that) addresses one of those reasons. Your Sins may still crash; but at least you'll be eliminating one possibility.
Sometimes, Sins may crash if the process has run out of virtual memory. 32-bit Windows executables (like Sins) can normally allocate just 2 Gigabytes of virtual memory. This limit is set regardless of whether your computer has 1 GB or 12 GB of RAM. For large Sins games, especially with mods, this 2GB limit is quite possible to hit. When it is hit, your Sins crashes.
The fix is extremely simple. Windows has built-in support for giving programs up to 3GB of virtual memory on 32-bit Windows, or up to 4GB of virtual memory on 64-bit Windows.By enabling this extended support, Sins can take up 3 or 4 GB of virtual memory instead of just 2. This doesn't allow you to run infinitely-large battles, but the amount of content you can fit into 3GB is quite a bit more than you can fit into just 2GB. And if you are running a 64-bit operating system, the full 4GB is available to you.
Enabling this support is a matter of some detail, but the basic idea involves tweaking some data inside the Sins executable (.exe) files. The file format is well documented, so this is not a "hack".
I have distilled this process down to the easiest possible solution for end-users. I am now offering a tool that will solve this problem for you. Just download the zip file in the thread link at the top; unzip it; and run it. The only thing to do when you run it is click the pop-up message box. You will need to run it again each time Sins is patched.
Here is what the pop-up message box should look like if the program runs correctly:

It will also pop up a black "console" window that will remain on the screen until the program is finished. Once it's finished, gear up to play Sins without any compromises!
Q&A
Q0: What if I don't have 3GB / 4GB of RAM?
A0: In general, having less RAM will just mean that Sins will run slower, and it will grind your hard drive more -- but it still shouldn't crash, even if it uses more than 2GB of virtual memory. You can reduce the amount of disk grinding by uninstalling or closing out unnecessary programs, to maximize the amount of free RAM you have.
If you have 1GB of RAM or less, you should really reconsider using pelaa-sins. It may slow your system down so much while playing Sins that it will become unresponsive. Better upgrade your RAM!
If you have 2GB of RAM, you should be able to play most games of Sins if it uses slightly more than 2GB of RAM. Close down unneeded programs, and run Windows XP instead of Vista/7 to minimize the operating system's RAM footprint. Use Sins Optimization Project to reduce the potential RAM usage of Sins.
If you have 3GB of RAM, you should be good to go! However, keep in mind that background programs and the operating system will eat considerably into the free RAM you have. Once your free RAM is exhausted, the hard disk will start to grind as it uses free disk space in place of RAM for virtual memory. You will still be able to play very large games of Sins, but you can improve performance by shutting down background tasks.
If you have 4GB of RAM or more, you can probably run multiple memory-intensive background programs while also playing Sins with pelaa-sins enabled. This is the ideal case, because your system won't slow down at all. I have tested this with 6GB of RAM and it's great.
Q1: What if your program screws up my Sins executables?
A1: The tool does not make any backups; if in doubt, you should back up any .exe files in your Sins directory. The application is programmed not to touch any other files, but just in case something goes catastrophically wrong, just be thankful that Stardock allows its customers to reinstall Sins an unlimited number of times. It is virtually impossible for the program to do anything really malicious, like delete all your files: there is nothing programmed into the executable to delete anything. In order for it to do that, something else on your computer would have to inject a virus into the pelaa-sins executable to make it misbehave.
Q2: How do I know if it worked?
A2: The simple answer is that you know it worked if your game doesn't crash and it's using more than 2GB of virtual memory (as evidenced by Task Manager). The long answer is that you can use my other program, pelaa (see https://forums.sinsofasolarempire.com/378149/get;2691196) to verify.
Q3: I got an error, or something else unexpected happened!
A3: Sorry about that! See the Troubleshooting section of this post.
Q4: How do I know your program isn't malicious?
A4: Run a virus scanner you trust on it! You should do that anyway. If you don't have a virus scanner, there are websites that will let you upload a file, and it will run 40 different virus scanners on the file. Google is your friend. Since the pelaa-sins.exe file is so tiny, all such websites should accept it as a submission. Aside from that, you can always download the source code instead and compile it from source; see below. This is much more difficult (and mostly defeats the purpose of making this available in a convenient-to-use format), but it does allow you to examine the program and positively determine that it is safe (if you're a programmer).
Q5: How do I know I've received the exact version of pelaa-sins.exe that you distributed?
A5: If your computer is free of malware/viruses and you download the zip file from the link in the post, you should be fine. However, if you have had problems with viruses/trojans/rootkits in the past, you may want to double check. Once you have unzipped pelaa-sins.exe, the exact file size should be 98,304 bytes. If you know what an MD5 Sum is, you can use your favorite MD5 Sum program (such as the one at http://www.md5summer.org/) to compare the sum in the "MD5SUM" file to the md5 sum of the executable. For reference, the md5sum is 97ec004f1965425d060f412446500d0e (August 6, 2010).
Q6: How do I get the source code of pelaa-sins?
A6: Install Git (http://git-scm.com) and clone the repository: git clone git://tiyukquellmalz.org/pelaa-sins.git
Q7: What does Pelaa-Sins stand for?
A7: Hopefully you know the "Sins" part, but "Pelaa" stands for "Portable Executable Large Address Aware". "PE" is the name Microsoft assigned to their executable file format, which is the standard format used for .exe files. "Large Address Aware" is the technical term used for the functionality that pelaa-sins (and pelaa) play with inside the PE headers.
Q8: How does this mod integrate with the Sins Optimization Project, or some other mod in general?
A8: Since pelaa-sins is not a "mod" in the traditional sense, it should (in theory) integrate perfectly with any mod. In addition, I hereby give explicit permission for any Sins mod to distribute pelaa-sins as a bundle with your mod, whether you ship an installer, a zip file, or whatever.
pelaa-sins and TSOP (The Sins Optimization Project) have similar goals. Both projects want to help people fit more mods and larger battles into Sins without it crashing. We approach this problem in completely different ways, but they are complementary ways. Therefore, I am maintaining this product as a standalone, but I am completely open to having other projects bundle pelaa-sins.
Q9: I've already used XYZ program to make my Sins executables large address aware; what about that?
A9: Then you have no need for pelaa-sins! The purpose of pelaa-sins was to create a utility that is easy to use, is designed specifically for Sins (it detects where your executables are using the registry), and doesn't involve breaking any license agreements (such as you do when you run Microsoft's editbin.exe without downloading the full Visual Studio). Perhaps more usefully, though, it allows people to bundle Large Address Aware support into their mod. Enabling large address aware for Sins is literally as easy as double-clicking on pelaa-sins.exe!
Troubleshooting
Windows XP 32-bit
Some configurations of 32-bit Windows XP do not automatically enable the "3GB Switch", which is an operating system-level switch that tells the operating system that it can give 3GB of virtual memory to processes with the Large Address Aware bit. More info about the 3GB switch: http://technet.microsoft.com/en-us/library/bb124810%28EXCHG.65%29.aspx
Updates
All updates to pelaa-sins will be announced in this thread, probably with an edit to the main post. However, the URL for downloading pelaa-sins will never change; old versions will be discarded and replaced with the newest version. In case you couldn't find it above, the URL is http://tiyukquellmalz.org/pelaa/pelaa-sins.zip
Contact / About Me
I'm a 24 year-old Software Engineer in Maryland, USA. I am a Sins fan, and generally an all-around PC gaming fanatic. I use Linux for most / all of my development and productive work when possible, and I mainly use Windows to play games. Pelaa and Pelaa-Sins were also developed on Linux.
If you are interested in contacting me to figure out how I did this, or are interested in software, programming, open source, etc., feel free to shoot me a forum private message.