Sage 100

 View Only
  • 1.  Sage 100 2025 Advanced Slow

    Posted 18 days ago

    Hi all,

    I have a test upgrade we are doing to 2025 on a Windows 2019 Server and the system is  is just crawling. 7-10 seconds to open a task.

     It's the same on the server or workstation.

    I worked through the performance KB and checked settings, adjusted the NIC, etc.

     It's running on hyper-V and has pretty killer level specs. Networking checks out fine too.

    So I used the trusty sysinternals tool to see whats happening - I took a proc monitor 'capture' of both the client and workstation to see where the delay was. from the client POV there's a TCP request that goes in and has a 3-4 second delay in the response from the server. 

    what I found interesting is on the server, the bulk of the load time seems to be the sage server is reading through the data files. The reads to C:\Sage100 are very very fast and take up only a very small portion of the time. However, the pvxwin32.exe process on server is also reading from the UNC path over SMB and that's very slow. If I sum up the time spend on the UNC path - in a 7 second capture, 3.09 seconds were just reading from the UNC.  

    SOTA.ini, the shortcut, the server, etc are all pointed at the C:\, I have no idea why sage would need to try to access the share drive on advanced!

    "2:25:35.3051028 PM","pvxwin32.exe","12040","ReadFile","C:\Sage\Sage100_2025\MAS90\MAS_System\SY_Context.M4T","SUCCESS","Offset: 8, Length: 248","0.0000075"

    vs 

    "2:25:35.2831818 PM","pvxwin32.exe","12040","ReadFile","\\sage2025v2\sage\Sage100_2025\MAS90\MAS_System\SY_Context.M4T","SUCCESS","Offset: 64,000, Length: 31,744, Priority: Normal","0.0328000"

    Am  I configuring something wrong? Is it normal for the sage server to be reading from the UNC and not the local drive?

    Any other ideas would be great...



    ------------------------------
    Calvin Morrison
    Operations Manager
    Kissinger Associates, Inc.
    215-429-9384
    ------------------------------


  • 2.  RE: Sage 100 2025 Advanced Slow

    Posted 18 days ago

    Isn't this now usually due to some version of variation of Threatlocker? The more that IT swears it's not the more likely that it is.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Connecticut
    ------------------------------



  • 3.  RE: Sage 100 2025 Advanced Slow

    Posted 18 days ago

    Are the paths in the service configuration tool local or UNC?



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: Sage 100 2025 Advanced Slow

    Posted 18 days ago

    Kevin,

    It is set to the C:

    image


    ------------------------------
    Calvin Morrison
    Operations Manager
    Kissinger Associates, Inc.
    215-429-9384
    ------------------------------



  • 5.  RE: Sage 100 2025 Advanced Slow

    Posted 17 days ago

    I believe I ran into this once before and it had to do with the VM NIC / vSwitch settings. Check this article out for a few things to try. 



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 6.  RE: Sage 100 2025 Advanced Slow

    Posted 17 days ago
      |   view attached

    Have you reviewed this kb?  Sage 100 performance issues in Hyper-V environment



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 7.  RE: Sage 100 2025 Advanced Slow

    Posted 17 days ago
    I thought that by testing the workstation on the server itself would rule out networking issues, does that seem like a correct or bad assumption?






  • 8.  RE: Sage 100 2025 Advanced Slow

    Posted 17 days ago

    I'm just assuming there is an impact since you said the "hardware" specs were decent and W2019 definitely added some networking wrinkles that Sage 100 didn't appreciate.

    Is there any performance difference if you use MAS 90 Mode via the local drive letters on the server?



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 9.  RE: Sage 100 2025 Advanced Slow

    Posted 17 days ago

    The workstation software accesses the service through a port #... and services listening for incoming connections on a port is a network function (...although a local workstation client may only use the higher layers of the TCP/IP protocol stack).

    Running in MAS90 mode (using local paths) would be a way to test without networking considerations.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 10.  RE: Sage 100 2025 Advanced Slow

    Posted 16 days ago

    I have a client just went live on v25.1 Premium x64 and the reported slow performance.   We worked thru the usual KBs and found adding the pvxwin64.exe to the AV Exclusions (in addition to pwxwin32.exe) improved performance significantly.   If you have not done that yet its worth a shot.



    ------------------------------
    Bruce Kern
    SWK Technologies Inc.
    ------------------------------