4 Replies Latest reply on Aug 27, 2015 12:29 PM by schamblee

    FileMaker performance while running on Windows

    bayern.to

      Hello,

       

      I'm experiencing a performance issue while working with FileMaker server hosted on Windows platform and would need some help.

      Testing Environment

      Machine A

      OS : Windows Server 2012 R2 with latest patch

      CPU : Xeon E5 4 cores 2.2GHz

      Memory : 8GB

      Harddisk : 200GB iSCSI storage

       

      Machine B

      OS : Windows 7 with latest patch

      CPU : Xeon W3520 4 cores 2.2Ghz

      Memory : 4GB

      Harddisk : 500GB local disk

       

      Problem Description

      Upload and host an database Product Catalog.fmp12(One of the sample DB comes with FileMaker Pro 13). Then I access the database from FileMaker Go 14 on an iPod, open any existing record or create a new one, select a container field and take a picture and then select the container field again and click "View". Here the problem comes as soon as I click "View" it start loading for about 2 minutes before I can see the picture in full screen.

      Look at the server side, during the loading period the fmserver.exe utilized the CPU but not fully. Look deeper into the process tree I can see the CPU loading is generating from MSVCR120.dll which is a Microsoft Runtime Library.

      fms_cpu_loading.PNG

       

      These behavior seem only occur at the first time I view a newly picture I insert into a container field. I had tested with both FileMaker server 13.9 and 14 on both machine, the same behavior are observed but not being seen while host the FileMaker Server on OSX. Is there any performance turning I can do for improvement?

       

      Best Regards,

      Bayern

        • 1. Re: FileMaker performance while running on Windows
          wimdecorte

          Instead of looking at fmserver.exe through the OS performance tools, make sure your FMS is set up to collect usage statistics logs (it's off by default).  With that on then look at the various counters FMS collects and see if you can detect where it spends its time.  The counters cover the 4 traditional bottlenecks: memory, processing, disk i/o and network throughput.

           

          I highly suspect that your usage of iSCSI may be an issue.  SAN is largely ok but when using dedicated fibrechannel, not iSCSI.

          Is this a virtual box?  Can you assign it a hard disk that is internal?

          • 2. Re: FileMaker performance while running on Windows
            schamblee

            You did not state if you were on wifi or 3G/4G/4G which can make a big difference nor did you state the size of the file you were displaying.  I would have a lower quality image to display on mobile device especially if you are using 3g.  I have FMS13 running on a windows 8 pro machine, 8Gb Ram, standard 7200RPM harddrive. I store hi-res images from an iPhone, the images are store and retrieved to display and both functions work well using wifi.  I have not tested using 3g/4g/LTE. 

            • 3. Re: FileMaker performance while running on Windows
              worldcloud

              iSCSI running through built-in ethernet 'screams' bottleneck, but iSCSI running through quad 10Gig Ethernet ports is far less expensive than Fibre Channel and much faster. Also he mentions iSCSI, but no mention of the drive system behind it. iSCSI running a small set of spinning disks with RAID-6 is going to be much slower than a larger set of SSDs running RAID-10 with a quality, active-active filer head.

               

              As the 'unofficial' defender of cloud architecture and virtualization- I have to agree with Wim that the shared iSCSI disk is suspect in this example, but I had to point out that there are ways to 'do it right' and have superior performance. i also have to point out that shared storage is often a key component in load balancing and fault tolerance in a virtualized environment.

               

              The implication in the response is that shared storage may be inferior to a local disk; however, when applied cautiously the use of iSCSI can create a system with no single point of failure- something that most FileMaker Server architectures can not claim.

               

              I concur with Wim's post; however, I just had to stick up for the 'virtual' guys...

              • 4. Re: FileMaker performance while running on Windows
                schamblee

                I agree with Win's post too. I was pointing out some additional factors.