> 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!