Jump to content

Server Problems. Please Help


Orlando

This topic is 6450 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

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

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

This topic is 6450 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.