[FX.php List] FileMaker performance issues during FMSA scheduled backups

[David Ness]

I can not get around the need to perform FMSA v9 scheduled backups on
our databases each afternoon at 12:00 noon. At the moment the backups
start, not only do our local (20+) clients start receiving the 'coffee
cup' upon virtually any interaction with the database using FileMaker
Pro, but our online fx.php clients are being affected as well, to the
point that timeout errors are occurring during page loads that involve
FMS interaction.

 

I would like to resolve this if I can. Solutions involving SQL are not
an attractive option.

 

All of our FileMaker software is of the latest versions and up to date.
The server runs no other software except Doubletake, which I do not
believe is the problem (the problem existing before out deployment of
Doubletake). The web server and FM server are separate machines. Our FMS
hosts about 100 files, of just under 10GB in size total. The backup
schedule completes in about 25 minutes.

 

The FMSA server hardware is fairly high-performance, a Dell rackmount
server, (2) Dual-Code 3.66Ghz processors, 4GB RAM, (6) brand new
internal 160GB drives in a RAID 5 configuration. I had heard during a
TechNet seminar that it's best to store the backup files onto a separate
partition (C: = OS, D: = FMSA, E: = Backups). I have though about
attaching another, separate RAID, just for the backup target, but don't
necessarily know if that will be of much help. I suspect that the
solution might lie elsewhere.

 

2 questions for the group:

 

1)       Do others have noticeable FMS/PHP performance issues during FMS
scheduled backups?

2)       Do you have ideas on how to resolve the issue? ALL ideas are
welcome.

 

Thanks!

 

 

 

 

David Allen Ness

Database Systems Programmer

Web Applications Developer

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20081009/dae3c896/attachment.html