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

[Joel Shapiro]

Hi David

Are you having FMS verify the files during backup?  This slows down  
backups considerably.

If you are, perhaps you can turn that off during your noon backup and  
have the verification run only during midnight backups.

HTH,
-Joel


On Oct 9, 2008, at 9:58 AM, David Ness wrote:

> 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
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list