Orlando Posted September 19, 2006 Share Posted September 19, 2006 I hope you guys can help. We are running FileMaker Server Advanced 8v4 The system is constantly slowing down and often grinding to a complete halt, we think we have isolated the cause to users performing finds in certain fields, but this should not cause the system to crash surely. This is causing severe issues as when it happens everyone using FileMaker is affected. Looking at the server monitoring software we use, the processor is being heavily hit at the times of slowdown, over 60%, and there appears to be nothing we can do. FileMaker is serving 86 files, all recently converted single table files. About 100 users. Server spec is: Windows 2003 SP1 2x Intel Xeon 3.40GHZ (HT) 4GB RAM 6400 Controller 192MB - RAID 5 15k disks for FileMaker Only. (75% Read / 25% Write) 6i Controller 64MB - RAID 1 15K disks for Operating System. (100% Read) FileMaker 800MB CACHE We have run out of ideas of how to resolve this, and it is causing serious disruption to the running of the company. If anyone has any ideas on how we can improve things then please let me know. Thanks in advance. Orlando Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted September 19, 2006 Share Posted September 19, 2006 What exact version of the FileMaker Pro client are you running to access these files? What amount of memory is set to be reserved for cache for these clients? Steven Link to comment Share on other sites More sharing options...
Orlando Posted September 19, 2006 Author Share Posted September 19, 2006 We are mainly using FileMaker Pro 8.5 with the developement team using FileMaker Advanced 8.5. The cache for each client is the default of 8MB. Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted September 19, 2006 Share Posted September 19, 2006 Change the cache to 12 MB. You may have some indexing problems with a field that is causing the slow search. Close the files on the Server via the SAT Tool first. Then stop the server completely. Then open the file is FileMaker Pro or FileMaker Pro Advanced. In Define Database...locate the errant field(s). Turn its index off and then back on. Exit Define database and then exit FileMaker Pro. See if that helps. Steven Link to comment Share on other sites More sharing options...
Wim Decorte Posted September 19, 2006 Share Posted September 19, 2006 what does the performance monitoring say? What is causing the degradation in performance? The processor? Open threads? Memory? Link to comment Share on other sites More sharing options...
Orlando Posted September 21, 2006 Author Share Posted September 21, 2006 what does the performance monitoring say? What is causing the degradation in performance? The processor? Open threads? Memory? Where would I find out this information? Is it part of FileMaker Server or another application? Link to comment Share on other sites More sharing options...
Wim Decorte Posted September 21, 2006 Share Posted September 21, 2006 That's part of the OS. You'll find the performance monitor in the Admin tools. If you haven't worked with them yet, try and find a good book on the subject. The best practise is too use the performance monitoring to establish a baseline after you install FMS and everything is working well. When things go wrong you can then compare the current data with your baseline and spot the trends & differences, which will give you an indication of what is wrong. That and what is in the OS event logs. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6519 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now