Troubleshooting slow performance

• Identify when the issue began

  • Record the date the issue was first reported
  • Identify who reported the issue
  • Confirm when the system last worked properly, or note if it has never worked as expected

• Pinpoint where the performance issue occurs

  • Check if the issue happens on the server, on all workstations, or only on a specific workstation.
  • For printing issues, determine if it occurs during:
    • Print Preview
    • Paperless Office printing
    • Use of a specific printer or all printers

• Locate Where and how the issue appears in the software

  • Observe if the issue occurs during:
    • Sage 100 startup
    • Opening a specific task window (for example, Sales Order Entry)
    • Opening task windows in other modules (for example, Purchase Order Entry)
    • Using lookup lists (for example, Customers, Items, Invoices)
    • Entering data in the Lines tab of a task window
    • Previewing vs. printing documents
    • Printing via Paperless Office or specific printers
    • Working in a particular company code (especially if it involves third-party enhancements or large data sets)

• Measure and compare performance

  • Start-up of Sage 100
  • The system slows when opening a task window for the first time. Examples include Sales Order Entry or Purchase Order Entry. This happens only on one module
  • Check if list lookups for Customers, Items, or Invoices slow down for one item or multiple items
  • Entering details in the Lines tab of a data entry task window
  • Check if previewing or printing slows down, especially with Paperless Office. Also check if this or occurs only with one printer or multiple printers
  • Performance differs by company code due to third-party enhancements or large data sets

• Test and Document Results

  • Test each suggestion below and record whether it made a difference
  • Document results clearly (for example, ping times, performance changes)

1. Ensure you set your antivirus software to exclude the specified folders and files on servers and workstations. For further information see, excluding Sage 100 from antivirus (antivirus) scans.
2. Disable SmartScan (Norton) or any aggressive scanning tools that can disrupt system operations.
   •  NOTE: If you’re using Webroot antivirus, you’ll likely have to uninstall. Disabling doesn't always work 
3. Set the antivirus to scan ONLY when starting up the workstation.
4. Set the antivirus to prompt for action rather than delete or rename the file.
5. Disable the scanning of network drives.
   • Scanning network files via mapped drives can lock up Sage 100—disable AV scanning on those paths. Deselect Network Scanning on all workstations.
6. Check for Antivirus Interference.
   • Physical server hosting a virtualized server running Sage 100
     • Identify and evaluate firmware-based or other antivirus tools installed on routers, VPNs, and cloud infrastructure
     • Confirm the firmware-based antivirus software isn’t affecting Sage 100 performance. This can happen even if it’s not installed on the workstation
   •  Symantec
     • Disable Tamper Protection as this can cause extreme lockups
     • Change the Proactive Threat Scanning from DEFAULT setting to once a day
     • Change the scan settings for modified files rather than accessed files
     • Avoid installing the Symantec End-Point Client directly onto the server. The scans will slow server processes
7. Temporarily disable antivirus and firewall. See if performance improves significantly.
   •  NOTE: With some antivirus products (such as Webroot), disabling the antivirus doesn't truly disable it. You need to uninstall it to test

• Network performance standards, according to the current Supported Platform Matrices (SPM)
  • Sage 100 Standard
    • Use PING with 1,800-byte packets and confirm response times are consistently 1–2 milliseconds
  • Sage 100 Advanced/Premium over a local area network (LAN) environment
    • Use PING with 1,800-byte packets and confirm response times are consistently less than 30 milliseconds
    • Unacceptable ping speeds are over 40 milliseconds
    • If network speed is slow, Sage 100 will perform well on the server but run slowly on workstations
• Use the Command prompt to run the PING test. To access the command prompt, press Windows key + R to open the Run dialog and type cmd 
  • Test how larger packets affect network performance using PING servername -l 1800
    • Use a lowercase L in the command
    • The 1800 is the size of the packet in bytes
    • The system will send four packets as part of this command
    • Performance varies. A 20 ms response time can feel slower than 1 ms
    • A 40 ms delay is outside the accepted range
  • Test network stability using PING servername -t
    • Use a lowercase T in the command
    • The system sends small packets continuously until you press Ctrl+C to stop it
    • If you lose packets, some data isn't getting through and this causes performance issues
• Windows 11
  • It’s reported that Windows 11 machines often default to Wi-Fi, even when Ethernet is available. If this happens disable Wi-Fi
  • Machines experience performance issues when they aren’t on the same network as the Sage 100 server. Windows 10 machines configured the same way don't show these issues
  • If you have problems with Windows 11 computers, ask your IT team for help. Checking the settings on Windows 10 systems working fine can help isolate the issue

• Launch Sage 100 as administrator. Right-click the Sage 100 shortcut and select Run as Administrator
  • Compare performance to when the shortcut isn’t Run as Administrator
  • If the performance improves, set the Sage 100 shortcut to always Run as Administrator
    1. Right-click the Sage 100 shortcut.
    2. Select Properties.
    3. Access the Compatibility tab.
    4. Under Privilege Level, select the checkbox: Run this program as an Administrator.
    5. Click OK to save change and close.
• At the server and workstations, set Data Execution Prevention to essential Windows programs only
  1. in Windows, Control Panel, System, select Advanced system settings.
  2. In the System Properties window that appears, access the Advanced tab. Click Settings in the Performance section/pane.
  3. In the Performance Options window that appears, access the Data Execution Prevention tab.
  4. Select the radio button: Turn on DEP for essential Windows programs and services only.

• Investigate if the issue began after a recent update
• Check for recent Windows Updates that can affect performance
• Review antivirus or firewall updates that reset settings or scanning exclusions
• Examine changes in backup software processes or behavior
• Look for enabled shadow copying or new performance monitoring triggers
• Look at rolling back recent Windows Updates to test for improvement
• Assume Sage 100 itself likely didn’t change or cause the issue

• Sage 100 Standard
  • Install Workstation Setup from a mapped drive above MAS90; shortcut must use the same mapped path
  • Ensure the shortcut uses a mapped drive letter pointing to a directory above the MAS90 folder
    • For further information see, slow performance when running Sage 100 ERP Standard through a UNC path
• Sage 100 Advanced and Premium
  • Install Workstation Setup from a UNC path; ensure the Sage 100 shortcut also uses the same UNC path
  • The UNC share point must be a directory above "MAS90" folder
    • For further information see, installing Workstation Setup for Sage 100

1. Log into Sage 100 as the Administrator user to access the Administrative Tools panel.
2. Select Sage Product Enhancement Program to open the Sage Product Enhancement Program window.
3. Deselect (uncheck) the Participate in Program checkbox.
4. Click OK.
5. Click Close to exit the Administrative Tools panel.

• Customers who host Sage 100 remotely or on a virtual machine can experience slow or degraded performance
  • Lag time, physical distance, and virtual environment complexity often cause delays or system hangs
  • Multiple virtual servers can run on one physical machine, with only one hosting Sage 100
  • Other servers can consume processor time, memory, or bandwidth
  • The Sage 100 server can’t have enough allocated resources
  • Sage 100 Customer Support can’t troubleshoot these infrastructure-related issues
  • For more information, see supported virtual platforms or virtualized operating systems for Sage 100
• If running Sage 100 on Windows 2019 Server in Hyper-V Environment, try one of the steps below
  • Disable RSC for IPv4 traffic
    • On the workstation client using PowerShell: Disable-NetAdapterRsc -Name $nic -IPv4
  • Disable Hyper-V vSwitch's
    • Check a Hyper-V vSwitch's current RSC status using PowerShell:
      Get-VMSwitch | Select *RSC*
    • Disable a Hyper-V vSwitch's RSC in full using PowerShell:
      Set-VMSwitch -Name $vSwitch -EnableSoftwareRsc:$FALSE
       NOTE: This won’t impact existing vSwitch connections

• Shadow Copy (also called Volume Shadow Copy Service, Volume Snapshot Service, or VSS) will delay file operations
• Incremental or continuous backup processes can slow read, write, and file lock or unlock attempts
• Microsoft OneDrive syncing interferes with Sage 100 performance
• SQL Mirroring causes delays or system hangs
• Avoid syncing the "Sage 100" folder in C:\Users\<username>\Documents with Microsoft OneDrive
• Avoid redirecting the "Documents" folder to another device such as a network-attached storage (NAS)

• Sage 100 Advanced and Premium check the server’s default printer each time you launch a task
• Sage 100 Standard edition checks the workstation's default printer
• Network Printers:
  • Make sure all Network Printers are on-line
  • If a Network Printer is off-line and no longer needed, remove it using the Windows Control Panel
    1. Open the Control Panel (press Windows key + R, type control, and press Enter).
    2. Click Devices and Printers under the Hardware and Sound category.
  • Redirected printers in Citrix, Terminal Services, or RDS often print slowly, incorrectly, or fail entirely
    
    • Try disabling the redirecting of printers

See, troubleshooting printing problems in Sage 100