Sage 100

 View Only
Expand all | Collapse all

Performance Issues After Installing Sage 2020 PU3

  • 1.  Performance Issues After Installing Sage 2020 PU3

    Posted 07-13-2021 12:42
    After installing 2020 PU3, I received several calls RE: performance issues.  There was a 5-6 second delay after entering a vendor number, a customer number or a GL account number during data entry.  I found running the Build Search Index utility resolved the problem.  Obviously then I had to schedule the index to run on a regular basis.

    ------------------------------
    Mary Jo Krueger
    Senior Software Consultant
    CLA (CliftonLarsonAllen LLP)
    Appleton WI
    920-996-1176
    ------------------------------


  • 2.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-13-2021 12:47
    Rebuild the search index.  I had a similar issue yesterday. 

    John Wilder
    612-385-8890

    Sent from my iPhone






  • 3.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-13-2021 13:37
    This is probably not related.

    Just in case

    Sage says they have a patch coming in the next PU for 2020 and 2021 that is supposed to speed up some screens.

    https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=111968&sliceId=1&noCount=true&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=19479&cmd=displayKC&dialogID=1004990&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true

    ---------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ---------------------------------





  • 4.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-13-2021 15:36
    Interesting.  Wonder which screens?  I haven't noticed that on my 2021.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------



  • 5.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-13-2021 16:11
    @Wayne Schulz - Quite the in depth ​KB......  I will try the rebuild.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 6.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-13-2021 16:59
    My issue was basically on all the data entry windows.  In AP invoice entry, they had to wait 5-6 seconds for the vendor name to pop up before they could go onto the invoice number field.  Then on the lines tab if they didn't have a default GL account come in, it would take 5-6 seconds after entering the GL account before it moved to the next field.  Same with customers and GL accounts during SO and SO invoice entry and manual check entry.

    ------------------------------
    Mary Jo Krueger
    Senior Software Consultant
    CLA (CliftonLarsonAllen LLP)
    Appleton WI
    920-996-1176
    ------------------------------



  • 7.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-13-2021 20:05
    Just to clarify.  My office install and another client's 2021 is sluggish when entering information in the key fields (customer, vendor, so, item, etc).  We are NOT using the search index.  So the solution is to start using the search index (which sucks BTW)?


    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 8.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-13-2021 20:10
    This is so frustrating when I read about a simple search...and I had a case for 3 weeks with Sage..have installed in three different servers and they are still complaining... I am not thinking about the search...I just think about RETIREMENT!!!!!

    ------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ------------------------------



  • 9.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-21-2021 18:51
    Not sure if this will help you at all but thought I'd post it since it DID help my client on Sage 2020 Standard. I sent it to their IT group and they made this change and Sage was back to normal.

    Slow performance on VM with 2019 and windows 10.

     You may be seeing this due to Receive Segment Coalescing (RSC). In short, RSC is TCP segment aggregation that combines segments in order to process larger segments versus multiple small segments for efficiency. This was introduced as a default configuration change for Windows Server 2019 and has been the source of issues similar to yours in other environments.

    1. You can disable a client's RSC for IPv4 traffic using PowerShell: Disable-NetAdapterRsc -Name $nic -IPv4.
    2. You can check a Hyper-V vSwitch's current RSC status using PowerShell: Get-VMSwitch -Name $vSwitch | Select *RSC*.
    3. You can disable a Hyper-V vSwitch's RSC in full using PowerShell: Set-VMSwitch -Name $vSwitch -EnableSoftwareRsc:$FALSE. This will not impact existing vSwitch connections.


    ------------------------------
    Mary Mays
    Sr. Consultant, DSD Business Systems
    DSD Business Systems
    Goddard KS
    316-269-4264
    ------------------------------



  • 10.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-21-2021 19:09
    Edited by Alnoor Cassim 07-21-2021 19:09
    @Mary Mays - Thank you for sharing this! I have 3 cases of Hyper-V VMs having mystery slowness in Sage v2019 and v2020, where Server 2019 is always the guest o/s. I'll share this out and keep my fingers crossed.

    ------------------------------
    Alnoor Cassim

    Email: alnoor@asifocus.com
    Ph: 949-689-9887
    Orange County, CA
    ------------------------------



  • 11.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-22-2021 09:45
    What I was told was that this setting was disabled by default until Windows Server 2019, when it was enabled by default.  Hope it fixes your clients.

    ------------------------------
    Mary Mays
    Sr. Consultant, DSD Business Systems
    DSD Business Systems
    Goddard KS
    316-269-4264
    ------------------------------



  • 12.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 09:18
    it appears to be the resolution until they come out with 2020 PU4.

    ------------------------------
    Mary Jo Krueger
    Senior Software Consultant
    CLA (CliftonLarsonAllen LLP)
    Appleton WI
    920-996-1176
    ------------------------------



  • 13.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-13-2021 19:24
    Unfortunately, the Sage KB management is very poor so there's no telling whether this is related to a specific release, configuration, or some combination. We'll just have to wait and see if Sage pushes something out. I presume that this is being targeted for the next PU which if it releases at the same pace as prior years would mean we'd likely see something around September 2021.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 14.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-13-2021 20:14
    @Lourdes Sobrino - If I didn't have such good relationships with my clients, I would be signing up for Social Security Office​ benefits!1

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 15.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-13-2021 20:27
    It doesn't sound like this relevant here, but ...
    If you have APS integrated be sure to download the latest update (from a few weeks ago). Without it, your performance on anything touching AR or SO will turn to slowly-setting concrete.

    ------------------------------
    Jerry Norman
    At-Large BOD Member, 90 Minds
    Smartbridge Partners
    512.419.1444 x112
    ------------------------------



  • 16.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 11:23
    @Jerry Norman  What is the APS Build Number that replaced the slow version?​  Our client just installed 6.10.6.12.12 on 2019.  Is it only 2021 that APS caused the slow-down?

    ------------------------------
    Bob Pfahnl
    Manager - Silicon Valley
    DSD Business Systems
    San Diego CA
    408-641-0922
    ------------------------------



  • 17.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 17:28
    Our problem was with v2020, complicated by JobOps. The APS update was 2020 6.12.11.

    ------------------------------
    Jerry Norman
    At-Large BOD Member, 90 Minds
    Smartbridge Partners
    512.419.1444 x112
    ------------------------------



  • 18.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 06:44
    I was told by someone at Sage Pu4 for Sage 2020 and PU2 for Sage 2021. We had a case open with them because of all the issues we had with the Windows opening so slowly.

    Sent from my iPhone




  • 19.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 11:03
    Edited by Jeff Schwenk 07-14-2021 14:30
    So the solution for those that have NOT installed the latest PU is NOT install the PU and wait till the next PU release??????  For those early trail blazers, the client is simply SOL??

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 20.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 14:33
    Does anyone thing Sage really has a fix and is waiting for the PU release or they are just hoping to have it fixed by the PU release?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 21.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 15:28

    There is indeed a fix, and I know that because we've been screaming so loudly about the speed issues, Sage is asking if we want a pre-release copy....but it has to be registered specifically to a client.  And it is only for Sage 100 Standard, not Advanced or Premium.

     

    Sue Bennett | President

    Bennett/Porter & Associates, Inc.

    P. 503 620 3484 | F. 503 620 2765

    12559 SW 69th Ave | Portland, OR  97223

    Email address | www.benpor.com

    Bennett/Porter Blog facebook twitter

     

    The information in this email and any attachments is considered confidential. This information may be subject to legal, professional, or other privilege. It must not be disclosed to any person without our authority. If you are not the intended recipient you are not authorized to and must not disclose, copy, distribute, or retain this message or any part of it. Please return this message to the sender immediately and delete any and all copies from your system.

     

     






  • 22.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 15:44
    Any clue why the fix is only STD?  All of my 2020/2021 installs are ADV.  My reasoning is if client is taking the bait flipping to subscription, you might as well get an initial bump for the effort.  And why limit it to a single install.  Gives the impression it is not ready for prime time yet.  Scary.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 23.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 15:50

    Apparently the problem they've found and potentially fixed only relates to Standard and not Advanced or Premium.  The largest client we have complaining about the speed (they upgraded from V2014) is on Advanced.  And they are SO very unhappy and there is still nothing we can do for them...

     

    Sue Bennett | President

    Bennett/Porter & Associates, Inc.

    P. 503 620 3484 | F. 503 620 2765

    12559 SW 69th Ave | Portland, OR  97223

    Email address | www.benpor.com

    Bennett/Porter Blog facebook twitter

     

    The information in this email and any attachments is considered confidential. This information may be subject to legal, professional, or other privilege. It must not be disclosed to any person without our authority. If you are not the intended recipient you are not authorized to and must not disclose, copy, distribute, or retain this message or any part of it. Please return this message to the sender immediately and delete any and all copies from your system.

     

     






  • 24.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 15:51
    My completely uninformed guess is that due to the issues that Adv/Premium have in Azure environments, Standard will be THE platform of choice going forward, especially once it gets converted to SQL.

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



  • 25.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 16:03


    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 26.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 16:08
    What they won't highlight about SPC is it is a one server solution, meaning if users need to do things like run Excel queries (I mean, how common is that?!?), they need to log into the full desktop, meaning the Sage server just became a user environment... which is not a recipe for disaster at all.  Nope.  Totally safe in the age of the crypto-virus.

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



  • 27.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 16:11
    Wow, just Wow!

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 28.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 16:14
    Very interesting @Sue Bennett - My office installation is ADV and I certainly notice a difference after jumping on the v2021 PU1 band wagon.  My other client I moved up to PU1 is also on ADV.  So how they are NOT noticing this is interesting.  Get it be the grit in their eyes by keeping their head in the sand????


    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 29.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 16:16
    When version 2022 come out, SPC providers will get their installation media as a box of floppies...

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    Asheville NC
    678.273.4010 ext 5
    ------------------------------



  • 30.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 16:22
    @Phil McIntosh - that hit me just the right way and I actually guffawed.  At least I think I did.  Perhaps I hooted.​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------



  • 31.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-14-2021 16:31
    Please keep all comments in Urgent Support on topic since the entire membership gets bombarded.

    Robert Wood
    DDF Consulting
    352-615-5898





  • 32.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-21-2021 08:58
    So is there a consensus of a work around?  If you have not installed the latest PU's, Don't????  If you have, activate your search indexes????  Turn off your search index capability at the user level???  I want to move forward with v2021, but this is throwing a wrench into the works.

    Thoughts?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 33.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-29-2021 11:55
    re: performance issues, hot fixes are available for v2020 and v2021

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



  • 34.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-29-2021 17:39
    Edited by Jeff Schwenk 07-29-2021 17:45
    @Brett Zimmerman  -  Very much appreciate the heads up.  Any specific search word combination to find it?  Perhaps a path?  Sage does not make it easy to find.


    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 35.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-29-2021 17:44
    Try these: LM6021T for 2020LM7002T for 2021

    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------



  • 36.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-29-2021 17:47
    They are linked from the latest Product Update download pages too.

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



  • 37.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-29-2021 17:48
    Thanks.  I saw that one (was not hard to find) but I discounted the fix because my clients (as I am) are using Advanced with the issue.  Will this load for ADV?  Will ADV work after the install?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 38.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-29-2021 17:51
    Perhaps you are looking for the fix for Auto-Complete slowness.  LM7003T for 2021.1 and LM6022T for 2020.3 

    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------



  • 39.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-29-2021 17:57
    @Michelle Taylor - you ARE a master of the Sage search...  One is listed under the 2021 complete download, the second is listed under the PU 1 page....  Yikes, how did Google get so good??​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 40.  RE: Performance Issues After Installing Sage 2020 PU3

    Posted 07-29-2021 18:00
    All the credit goes to @Wayne Schulz!!

    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------