Slow performance when opening a new task or starting Sage 100, or when running Sage 100 across a network
Possible reasons for slow performance can be due to hardware or software issues on the network or operating system(s), virtualization settings, remote hosting issues, network or server traffic load, etc.
Suggestions of areas have been causes of slow performance.
DEFINE THE PROBLEM and record results:
When the issue began occurring? Date, Person, Server? One or more Workstation(s)? task(s), Company? Time of day/week?
When was it last working fine, or has it never worked properly?
Printing, does it happen during Preview or Paperless Office printing, specific printer or all printers?
Lookup of things in a list, like Customers, Items, Invoices, etc., where data-volume may be an issue.
Entering details in the Lines tab of a data entry task for huge transactions.
Involve a particular company? (quite a lot of company data or 3rd party enhancement) versus other company codes.
Time slow performance at server versus workstation (or one printer versus another), and whether actions you take reduce the lag time. Happen at a time of day or when another process (like a backup) may be running?
Test and record results.
Check for recent Microsoft Windows Updates or other software updates or changes. If slow performance issue only recently began, a recent update installed that is causing interference. Includes: Windows Updates, antivirus or firewall updates that change or reset settings or scanning exclusions, changes to backup software processes or behavior, enablement of shadow copying, performance monitoring triggers, etc. Windows updates can be rolled back to see if the slow performance issue is repealed. It unlikely that something changed in Sage 100.
Change the default printer to another physical or network printer and then test/check the performance. Sage 100 Advanced and Premium looks at the default printer on the server every time a task is launched. Sage 100 Standard edition checks the workstation’s default printer.
Make sure all Network Printers are on-line. If a Network Printer is no longer needed, remove it from the workstation via Windows, Control Panel, Devices and Printers. Redirected printers for remote connections (Citrix/Terminal Services/RDS) have been known to fail to print, or print incorrectly, or print very slowly. Try disabling the redirecting of printers.
Check the path:
For Sage 100 Standard, Workstation Setup should be installed from a mapped drive letter path, such that the shortcut to launch Sage 100 also has the mapped drive letter path. The drive letter must be mapped to a directory above “MAS90”
For Sage 100 Advanced or Premium, Workstation Setup should be installed from a UNC path, such that the shortcut to launch Sage 100 also has the UNC path. The UNC share point must be a directory above “MAS90”
Check antivirus settings exclude the following folders and files on server and workstations:
“..\MAS90” directory where Sage 100 is installed and where Workstation Setup is installed, and exclude the following executables as well:
“..\MAS90\Home\Pvxwin32.exe” “..\MAS90\Home\pvxiosvr.exe” “..\MAS90\Launcher\Launch32.exe”
“..\MAS90\Launcher\Launcher.old.exe” “C:\ProgramData\Sage\Common Components”
“..\Crystal Reports*” directory
Verify antivirus program has been configured to exclude the following files on both the server and workstations:
AUC, DCL, DD, DDE, DDF, EXP, LCK, LIB, KDF, M4D, M4L, M4P, M4T, M4X, PRM, PVC, PVX, RPT, SOA, XEQ
Disable Smartscan Technology (Norton) or any other aggressive (or “real-time”, “constant”, “on-access”, etc.) scanning utilities that may interfere with operations
Note: If using Webroot antivirus, you may have to actually uninstall, as disablement does not seem to always work
Set antivirus to scan ONLY when starting up the workstation, so that it does not interfere with normal operations.
Set the antivirus to prompt for action rather than delete or rename the file
Disable the scanning of network drives
If the AV software programs are scanning network files and the workstation has drive mapping to the server, this will lock up MAS90. Deselect Network Scanning on all workstations.
Compare performance to when the shortcut is not Run as Administrator
Check PING timing:
When running Sage 100 Advanced/Premium over a local area network (LAN) environment, the ping timings will vary depending on the speed of the network. Typical ping timings with 1,800 bytes of data should be 20-30 milliseconds or faster. Unacceptable ping speeds are over 40 milliseconds.” A classic issue would be where performance is fine on the Sage 100 server but slow at workstations (because of the network speed).
Note: Performance is along a spectrum, so even a 20 ms (milliseconds) response time may have a noticeable impact compared to 1 ms. 40 ms is considered unacceptable.
Check for possible interference from the Sage Product Enhancement Program. Disable this via Sage admin login.
Other factors:
Sage 100 host server should be a dedicated server. Having other applications running, such as Microsoft Exchange, another accounting or sales product, etc. affects performance.
Sage 100 hosted remotely and/or hosted on a virtual machine may encounter slow or degraded performance or hanging due to lag time/distance or the additional layers and complexity involves with simulating a virtual operating system. Multiple virtual servers on a physical machine, of which only one of is the Sage 100 server. Other servers may be actively taking up processor time, memory, and bandwidth – or there may be insufficient resources allocated to the Sage 100 server.
Customers with VoIP telephony also have reported bandwidth issues. Also, according to the Supported Platform Matrix, “Workstations from remote sites are supported only through Remote Desktop Services or Citrix. Running Sage 100 Standard over a Virtual Private Network (VPN) and/or a Wide Area Network (WAN) or through any other remote means is not supported”.
WiFi connections are not supported.