Sage 100 very slow over network

SOLVED
We have Sage 100 Enterprise at the company I support. Performance directly on the host server is lightning fast, but on client PCs over the network it is painfully slow, especially when printing to paperless and opening Adobe Reader. I have followed every step I can find on the Sage Forums with pretty much no improvement. Here is a summary of our setup:
  • Sage folders are hosted on a Hyper-V VM with 8 Virtual Processors and 8GB RAM
  • Sage Shared folder has All Users and SYSTEM with Full Access
  • IPV6 is disabled on both Host and client PCs
  • Using Windows Security on Host and Clients with the below file/folder/extension exceptions
    • "..\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
    • "C:\Program Files (x86)\SAP BusinessObjects"
    • AUC, DCL, DD, DDE, DDF, EXP, LCK, LIB, KDF, M4D, M4L, M4P, M4T, M4X, PRM, PVC, PVX, RPT, SOA, XEQ extensions
  • File Server Resource Manager file screening is enabled on the server to prevent ransomware, however all the above extensions are exempted.
  • Windows Firewall rules allowing the above .exe files all incoming and outgoing ports
  • Recv Segment Coalescening is disabled on Hypervisor and Host VM.
  • Building networked with a Unifi 1Gbps switch
I have followed essentially every applicable recommendation from here: https://support.na.sage.com/selfservice/viewContent.do?externalId=30079&sliceId=1
Has anyone else encountered this? How were you able to speed things up on your network?
  • 0

    What version of Sage 100 (v2021, v2022, etc.)?  Sage 100 Standard, Advanced (CS) or Premium (SQL)?  If Standard is it a mapped drive?  if not standard is workstation installed as a UNC?  Are the users in the same building as the server or in different buildings?  Are the users hard wired to the network or on wireless?  Do they have problems with data entry (like Sales Order Entry); or is it just printing and posting registers and journals? Do you have the Data Execution Prevention set per that document?  Has something changed in the network configuration, or version? 

  • 0 in reply to StefanouM

    Thanks for the reply, to answer your questions:

    • Version is Sage 100 Standard 2019
    • It is to a mapped drive
    • Users are all in the same building as the server
    • All users are hardwired, no one over WiFi
    • Data entry is usually okay, it only slows to a crawl when they click proceed or print
    • DEP was set correctly on a couple of the workstations, but not the server I have noticed. I will do that and see if it helps.
    • Nothing has changed in network config aside from a new Switch and going from a physical to a virtual server, however these problems were there before doing that, which is why we made these changes to begin with.

    Hope this helps!

  • 0 in reply to StefanouM

    I checked in with the employees this morning, setting DEP to the Essential functions only on both the server and client did not seem to help

  • 0 in reply to Darth_Alicious

    How many users are in at a time? Users, I usually don't like to see more than 10 Standard Users, more than that I recommend Advanced or Premium. Not a requirement, I have seen 20+ users on Standard. With Standard it is going over the network with tons of data back and forth, so it cuts out a lot of traffic. Printing and creating the PDF is always local so being on Advanced or Premium wouldn't change that but it would remove all the traffic of the data entry down to a minimum. 

    How big are the data files for the company? Since you are on Standard, this is running locally on each machine. The speed of data entry and printing are all related to the client and its ability to open files over the network from the server. If data entry appears OK but Printing is slow, then it tells me you might have large data files and if they are segmented it could really slow things down. You can usually see this when you print different things and the speed changes. Like a chart of accounts from the ABC demo company compared to Invoice History printing in your live company. The faster you have Disk read on the Server, Network speed to the client and the client with enough CPU/Memory to process it, the better it is for Standard. It is fast on the server since you took out the network, Disk I/O with filesharing and it is probably an extremely high-powered machine to run Sage compared to the clients (I am guessing, but you might have beefy clients).

    One thing I will say, is that I have done site surveys when issues like this happen, and I find one of two things that get overlooked. The client workstation is going through a VOIP phone (Phones ethernet out may decrease your 1GB to 100 MB), or they have smaller (cheaper and not as good or as fast) switches to extend the room to more devices. Thes smaller switches tend to have issues as they are usually hidden under the desk and kicked, under powered, or OLD as dirt with issues.

    Hope that helps

  • 0

    You aren't crazy and we are having similar issues in environments that are also utilizing Hyper-V and Unifi switches.

    We have tried everything within Hyper- V from legacy NIC teams, the new SET NIC teams, virtual switches with dedicated NICs, and whitelisting in AV products. It really seems like something is wrong with how Sage interacts with the network at the operating system level on newer Server 2019 and Server 2022 Hyper-V host.

    Were you ever able to find a solution?

  • 0 in reply to MSP Crew

    Alas, we have not. I tried every single suggestion I found anywhere, but nothing made any difference, at least not on a noticeable scale. We eventually gave our most active user at each business we manage remote desktop access to the server that Sage Paperless saves to and let them work on a Sage installation there, and that improved their experience dramatically. However, the rest of the users are still stuck with painfully long waits when they print anything to paperless. We are looking at maybe trying using Microsoft RDS or Citrix to try letting multiple users do this, but haven't gotten that far yet.

  • 0 in reply to Darth_Alicious

    That might be anti-virus slowing down the PDF creation.  Have you tried adding an exclusion for the Paperless path?

  • 0 in reply to Darth_Alicious

    We are seeing slowness in Sage across the board and with many applications that pull data from it via OBDC.

  • 0 in reply to Kevin M

    Yep, I have a excluded the paperless folder, as well as all the following, per Sage recommendations:

    File Extensions:

    "AUC"
    "DCL"
    "DD"
    "DDE"
    "DDF"
    "EXP"
    "LCK"
    "LIB"
    "KDF"
    "M4D"
    "M4L"
    "M4P"
    "M4T"
    "M4X"
    "PRM"
    "PVC"
    "PVX"
    "RPT"
    "SOA"
    "XEQ"

    Folders:
    "$Sage"
    "$Sage\MAS90\Home\pvxwin32.exe"
    "$Sage\MAS90\Home\pvxwactv.exe"
    "$Sage\MAS90\Launcher\Launch32.exe"
    "$Sage\MAS90\Launcher\launcher.2016.exe"
    "$Sage\MAS90\Launcher\launcher.old.exe"
    "C:\Program Files (x86)\SAP BusinessObjects"
    "C:\ProgramData\Sage"
    "C:\Program Files (x86)\Common Files\Sage\Common Components"

    Any others you might recommend?

  • 0 in reply to MSP Crew

    Yeah, that has been our experience too. Paperless seems to be the worst offender, but quite a few people have issues with it when it initially starts up as well. I forgot to mention that for one of our clients, turning off Windows Firewall on the Sage host VM helped a bit with startup slowness, but not for the other two. I excluded all the ports they recommend, and I ran Wireshark to see what other ports it was using but found nothing, so no idea why that helps, but it does.