Hi,
Thanks for your query.
The messages will be flagged for deletion fom the database once all references are removed, this may take up to 24 hours. The database will not grow indefinitely if tracking information is not stored, only current and recent messages are maintained.
Large messages (up to 4GB) are supported, but your server should be 64-bit and will require a significant amount of memory (8GB+, ideally 16GB). In this configuration you will not receive out of memory errors.
As a rough guide, assume each processor core will be handling 10 messages simultaneously and will store 2 transient copies of each message (regardless of the actual throughput rate, as garbage collection in the .Net layer smoothes this out). If each message is for example on average 100MB, and you have a quad-core processor, you should populate the server with 100 * 4 * 10 * 2 = 8GB of RAM in addition to that required for the o/s and other applications. If SQLServer is running on the same machine, add 50% more.
Luckily these days RAM is cheap!
Thanks,
Ben.
Ben Jackson
SmartsIntegrator Technical Support