Slow performance when running Sage MAS 90 on a network

 

  •  

    MAS 90/200 version 4.x seems to run slower than it did in version 3.x. What causes this and how can it be corrected?

    Product: Sage MAS 90 and MAS 200 ERP
    Module: Crystal Reports
    Version: 8.50 and 10.0
    CID Reference: 1234

     

    Screen load time in Version 4 is expected to be a little bit slower than in Level 3. It should not be markedly slower. With Sage MAS 90 4.00 and higher, the use of objects in the programming has increased the amount of file processing that takes places over the network. Sage Software has determined the presence of antivirus software may cause slow performance in screen loading and in some cases slowness in Crystal form or report printing as well.

     

  • Sage Software has issued a Sage MAS 90 v4.0 Performance Update statement in regard to this matter. The following are the results of research performed relating to performance.

  • Slow performance on screen load occurs in the following scenarios:

  • 1.Insufficient available physical memory without consideration to any other factors. One method of measuring this is to view the Available Physical Memory reported by Windows in the Task Manager utility on the Performance tab. Another method is to compare the measurement of the Total Commit Charge statistic against the Total Physical Memory count. These measurements can also be viewed in the the Performance tab of the Task Manager.

  •  

  • In the example above, Windows has just been rebooted and Sage MAS 90 has not been started yet. Notice the available physical memory is only 22 MB and the Total Commit Charge is nearing the Total Physcial Memory. Additional memory should be added to the workstation.

  • 2.The installation of Symantec Home or Home Office based products such as Norton AntiVirus, Norton Internet Security (the antivirus component), Norton SystemWorks (the antivirus component) may impact performance.

  • To determine whether this is the cause, temporarily disable the antivirus software on the workstation, and then open a task from the Sage MAS 90 Business Desktop (Launcher). Compare the screen load time with antivirus enabled.

  • The Home / Home Office based products are not configurable in terms of automatic, background realtime scans of network drives. The realtime memory-resident feature that performs these "on-the-fly" scans is known as AutoProtect. Although manual scans can be performed so network drives are excluded, AutoProtect does not allow for network drive exclusions. Additionally, for network drives only, AutoProtect does not allow setting exclusions by file extension, or scanning by inclusion (that is, choosing SmartScan over Comprehensive File Scanning).

  • Sage Software has contacted Symantec regarding the Home / Home Office based antivirus products and whether AutoProtect can be configured in any way to disable or change the behavior of network drive scans. Symantec has indicated that this is not possible with the "off-the-shelf" editions. They also indicated that the "off-the-shelf" editions are not intended for use in a corporate environment and are only intended for home use.

  • Note there may exist other brands of Home / Home Office based antivirus sofrtware made by vendors other than Symantec that also do not have configurable scanning options for automatic realtime scanning of network drives. As a result, Sage Software recommends using a corporate, enterprise, or professional version of antivirus software that has configurable realtime scanning options for network drives.

  • 3.The default installation of a Symantec Enterprise-based product such as Symantec Antivirus Corporate Edition or Symantec Antivirus Enterprise Edition may impact performance.

  • To determine whether this is the cause, temporarily disable antivirus on the workstation, and then open a task from the Sage MAS 90 Business Desktop (Launcher). Compare the screen load time with antivirus enabled.

  • The Enterprise-based products are configurable for realtime memory resident scans. This feature is known as File System Realtime Protection or AutoProtect, depending on which version of the product is installed. The following changes can be made in the File System Realtime Protection properties to improve Sage MAS 90 screen load performance, listed in the order of best performance.


  • a.By default, network scans are selected via the Network check box. If you have already protected the system by installing antivirus software running with the latest signatures on the server and every other computer in the network, consider clearing this check box. The best performance gain is achieved through this setting. With this setting, no other changes are required. In all likelihood, the screen load time will be the same as if File System Realtime Protection was disabled.

  • b.For File Types, consider choosing Selected over All Types. This "inclusion" setting indicates scanning is done only on the selected file extensions listed when clicking the Extensions button. On some versions, when the Extensions button is clicked, a SmartScan check box becomes available. Consider not enabling SmartScan for better performance.

  • c.Under Options, consider selecting the Exclude selected files and folders check box. Then in the subsequent dialog, select the Check file for exclusion before scanning check box. This is known as a "prescan exclusion". Not selecting it causes a "postscan exclusion" to occur, which means the files in the exclusion list are still scanned for viruses but any viruses found are not reported.

  • The exlcusion list should include the following file types:

  • SOA
    M4T
    M4P
    M4L
    M4D
    PVC
    LIB
    RPT
    XEQ
    DD
    DDE
    DDF

  • 4.Installation of antivirus products from vendors other than Symantec, where the default configuration has been changed so the memory-resident automatic scans include network drives, may impede performance. For example, if McAfee VirusScan Enterprise is installed, by default it does not automatically scan network drives. As a result, slow screen load performance does not occur in Sage MAS 90. However, if the default is changed so network drives are scanned, slow performance occurs.

  • 5.Running on a 10-Base T network.

  • 6.Enabling the MS Shadow Copy service or Volume Shadow Copy service on the server. Due to the increased amount of file transfer with Version 4, these types of services are always actively running at the server.

  • Copyright © 2014 Sunrisenm. All Rights Reserved.
    Joomla! is Free Software released under the GNU General Public License.