We probably need a little more information to diagnose the issue. 25 users on 3 databases is well within FileMaker's capabilities. There is a fair number of issues that can affect performance:
- Server hardware
- Network bandwidth
- User load
- Processes running on the server
- Database design (including issues like table width, graphic use, unstored calculations, calculation optimization, relationship graph design, and others)
What changed between the time performance was adequate and now? That's where I would start looking.
Please post your current harware
Keep in mind, it could be something simple. I once had a single bad ethernet cable muck up performance
"ping" your machines, and look for errors
> I am looking for any advice on how to increase speed and also how to get a quanative analysis of what 'slow' is. I would imagine that a simple solution would be to upgrade my Hardware and Software
I would upgrade to server 11, check how much ram is allowed to FM server and check your hard drive performance. Fast drives make a difference. Also turn off any services on the server you don't need. I assume it's running standard and not SBS which is not supported.
Here is what I have:
Windows Server 8
You mean Windows Server 2008, right?
we did improve speed very much by replacing the servers Harddrive with a SSD !
sure, speed depends very much on the structure of your calculation fields and script steps. but beside this, the SSD was a greate improvement.