> There's another resource aspect in this case, too: SS is a single process > running on a 32-bit server so it's limited to 2GB total memory. So, with "9 > separate database files for each of the connecting agencies" and an unknown > number of connections to each database by each agency, there will be a > tipping point where there's not enough RAM to make a new connection. >
Interesting! Again, I'm fairly new at trying to see how many connected sessions, usage, etc. I can say, though, that there is one 2.2 GB file, and 8 roughly 20 MB files making up those 9. If it helps, this is a unique site of ours, where multiple live agencies are using a single DB server instance. There are plenty of departments though, with 100 GB+ db files, and I'd estimate 25-50 concurrent users. Do you have a recommendation on a free/cheap DB Monitoring tool for Firebird? Thanks!
