Sage 100

We upgraded a Sage 100 Standard account with 10 users to a new server running Server 2019.  To open a task on the server takes 3-4 seconds but 10-12 seconds on a workstation.  Our client has an advanced IT specialist on staff that has determined this is due to Microsoft rewriting the TCP/IP Windows Networking Stack to be optimized for Azure and cloud servers.  He references this link about this being a known Microsoft issue for anyone on a local network. 

https://community.spiceworks.com/topic/2225989-server-2019-network-performance?page=1 

The client has a Gold support plan with Sage and has shared this information with Sage Technical Support.  Sage has had several speed complaints on Server 2019 but has not come up with a reason.  Sage has now been able to recreate this scenario.  Our client was able to spin up a new server running Server 2016 and connect the drive that has Sage standard installed to the 2016 operating system.  All speed issues go away with this configuration.  I'm not the technical person but wanted to share this recent experience.  Our IT consultant/client recommends not installing Sage Standard on Server 2019.  He doesn't know if Sage will be able to figure out a work around or fix to this since Microsoft has known about these issues for almost a year and has not provided a fix.

------------------------------
Steve Engmann, MBA, CMA
Competitive Strategies, Inc.
Appleton, WI
920-993-1077
------------------------------

Wow... OK, upgrades for Standard, recommend Server 2016... thanks for sharing!

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

So M$ answer to local communication being faster than internet communication is to slow down the local network?!?!?  How Sage of them...

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

I didn't read the whole thread, but what I did see referenced read caching (with earlier references to data integrity pertaining to mirroring in VM).  With Standard being very read-write intensive, any performance hit with file caching could really cause problems.


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

Original Message:
Sent: 12-01-2020 17:39
From: Phil McIntosh
Subject: Sage 100 Standard slow response on Server 2019

So M$ answer to local communication being faster than internet communication is to slow down the local network?!?!?  How Sage of them...

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

Any input on Advanced compared to Standard on Server 2019?

------------------------------
John Wilder
Technology Integrators
------------------------------

Original Message:
Sent: 12-01-2020 17:52
From: Kevin Moyes
Subject: Sage 100 Standard slow response on Server 2019

I didn't read the whole thread, but what I did see referenced read caching (with earlier references to data integrity pertaining to mirroring in VM).  With Standard being very read-write intensive, any performance hit with file caching could really cause problems.

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


Original Message:
Sent: 12-01-2020 17:39
From: Phil McIntosh
Subject: Sage 100 Standard slow response on Server 2019

So M$ answer to local communication being faster than internet communication is to slow down the local network?!?!?  How Sage of them...

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

@John Wilder Sage Tech Support has not seen the same slow speed issue with Advanced and Server 2019. ​

------------------------------
Steve Engmann, MBA, CMA
Competitive Strategies, Inc.
Appleton, WI
920-993-1077
------------------------------

Original Message:
Sent: 12-01-2020 21:26
From: John Wilder
Subject: Sage 100 Standard slow response on Server 2019

Any input on Advanced compared to Standard on Server 2019?

------------------------------
John Wilder
Technology Integrators
------------------------------


Original Message:
Sent: 12-01-2020 17:52
From: Kevin Moyes
Subject: Sage 100 Standard slow response on Server 2019

I didn't read the whole thread, but what I did see referenced read caching (with earlier references to data integrity pertaining to mirroring in VM).  With Standard being very read-write intensive, any performance hit with file caching could really cause problems.

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


Original Message:
Sent: 12-01-2020 17:39
From: Phil McIntosh
Subject: Sage 100 Standard slow response on Server 2019

So M$ answer to local communication being faster than internet communication is to slow down the local network?!?!?  How Sage of them...

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

@Kevin Moyes. Is file caching the same as paging? If so, would simply adding more memory fix the issue by reducing swapping space between disk and memory?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Original Message:
Sent: 12-01-2020 17:52
From: Kevin Moyes
Subject: Sage 100 Standard slow response on Server 2019

I didn't read the whole thread, but what I did see referenced read caching (with earlier references to data integrity pertaining to mirroring in VM).  With Standard being very read-write intensive, any performance hit with file caching could really cause problems.

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


Original Message:
Sent: 12-01-2020 17:39
From: Phil McIntosh
Subject: Sage 100 Standard slow response on Server 2019

So M$ answer to local communication being faster than internet communication is to slow down the local network?!?!?  How Sage of them...

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

@Doug Higgs 
Not really, and maybe.
I'm not an expert in these things at all, but AFAIK: caching is loading / keeping files in memory which might be needed, while paging is when there is not enough physical memory so Windows uses the paging file(s) as virtual memory.  Cache problems can certainly affect paging, but they are different concepts.
Again, I only read a couple pages (of over 200!) but there was a comment in the thread that implies more memory can help with the issue, and that older software is more vulnerable to issues.

​

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

Original Message:
Sent: 12-01-2020 22:48
From: Doug Higgs
Subject: Sage 100 Standard slow response on Server 2019

@Kevin Moyes. Is file caching the same as paging? If so, would simply adding more memory fix the issue by reducing swapping space between disk and memory?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------


Original Message:
Sent: 12-01-2020 17:52
From: Kevin Moyes
Subject: Sage 100 Standard slow response on Server 2019

I didn't read the whole thread, but what I did see referenced read caching (with earlier references to data integrity pertaining to mirroring in VM).  With Standard being very read-write intensive, any performance hit with file caching could really cause problems.

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


Original Message:
Sent: 12-01-2020 17:39
From: Phil McIntosh
Subject: Sage 100 Standard slow response on Server 2019

So M$ answer to local communication being faster than internet communication is to slow down the local network?!?!?  How Sage of them...

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

Thanks @Kevin Moyes  My thought was if there wasn't available cache then paging may have to occur, creating the latency.  Of course, I didn't read it at all, so just speculating.  If it was that easy they probably wouldn't be using 200 pages to document the issue.   
​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Original Message:
Sent: 12-02-2020 10:10
From: Kevin Moyes
Subject: Sage 100 Standard slow response on Server 2019

@Doug Higgs
Not really, and maybe.
I'm not an expert in these things at all, but AFAIK: caching is loading / keeping files in memory which might be needed, while paging is when there is not enough physical memory so Windows uses the paging file(s) as virtual memory.  Cache problems can certainly affect paging, but they are different concepts.
Again, I only read a couple pages (of over 200!) but there was a comment in the thread that implies more memory can help with the issue, and that older software is more vulnerable to issues.

​

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


Original Message:
Sent: 12-01-2020 22:48
From: Doug Higgs
Subject: Sage 100 Standard slow response on Server 2019

@Kevin Moyes. Is file caching the same as paging? If so, would simply adding more memory fix the issue by reducing swapping space between disk and memory?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary


Original Message:
Sent: 12-01-2020 17:52
From: Kevin Moyes
Subject: Sage 100 Standard slow response on Server 2019

I didn't read the whole thread, but what I did see referenced read caching (with earlier references to data integrity pertaining to mirroring in VM).  With Standard being very read-write intensive, any performance hit with file caching could really cause problems.

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


Original Message:
Sent: 12-01-2020 17:39
From: Phil McIntosh
Subject: Sage 100 Standard slow response on Server 2019

So M$ answer to local communication being faster than internet communication is to slow down the local network?!?!?  How Sage of them...

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

The 200 pages is history of troubleshooting, with some conclusions coming out after a lot of group effort.  Not an official M$ source, just a bunch of skilled system administrators trying to figure out the problem.
Apparently with Server 2019 the cache loads more stuff it doesn't need, and isn't as diligent at clearing out that stuff it doesn't need, chewing up memory needlessly (causing the performance hit).

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

Original Message:
Sent: 12-02-2020 11:10
From: Doug Higgs
Subject: Sage 100 Standard slow response on Server 2019

Thanks @Kevin Moyes  My thought was if there wasn't available cache then paging may have to occur, creating the latency.  Of course, I didn't read it at all, so just speculating.  If it was that easy they probably wouldn't be using 200 pages to document the issue.
​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------


Original Message:
Sent: 12-02-2020 10:10
From: Kevin Moyes
Subject: Sage 100 Standard slow response on Server 2019

@Doug Higgs
Not really, and maybe.
I'm not an expert in these things at all, but AFAIK: caching is loading / keeping files in memory which might be needed, while paging is when there is not enough physical memory so Windows uses the paging file(s) as virtual memory.  Cache problems can certainly affect paging, but they are different concepts.
Again, I only read a couple pages (of over 200!) but there was a comment in the thread that implies more memory can help with the issue, and that older software is more vulnerable to issues.

​

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


Original Message:
Sent: 12-01-2020 22:48
From: Doug Higgs
Subject: Sage 100 Standard slow response on Server 2019

@Kevin Moyes. Is file caching the same as paging? If so, would simply adding more memory fix the issue by reducing swapping space between disk and memory?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary


Original Message:
Sent: 12-01-2020 17:52
From: Kevin Moyes
Subject: Sage 100 Standard slow response on Server 2019

I didn't read the whole thread, but what I did see referenced read caching (with earlier references to data integrity pertaining to mirroring in VM).  With Standard being very read-write intensive, any performance hit with file caching could really cause problems.

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


Original Message:
Sent: 12-01-2020 17:39
From: Phil McIntosh
Subject: Sage 100 Standard slow response on Server 2019

So M$ answer to local communication being faster than internet communication is to slow down the local network?!?!?  How Sage of them...

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