Salesforce

Performance degradation for remote clients connected to databases when Windows TCP/IP features are enabled

« Go Back

Information

 
TitlePerformance degradation for remote clients connected to databases when Windows TCP/IP features are enabled
URL Name000052793
Article Number000170163
EnvironmentProduct: Progress
Product: OpenEdge
Version: All supported versions
OS: Windows 2008 R2, Windows 2012, Windows 2016, Windows 2019
Question/Problem Description
Intermittent performance degradation for remote clients connected to databases when Windows RSS, RSC, Windows Interrupt Moderation features among others are enabled on Windows Servers 

Performance is intermittently degraded for clients (_proapsv, _progress, prowin, _mproapsv) are connected to a remote database when Windows TCP segment aggregation and moderation features are enabled.

Client-Networking Applications perform poorly on specific sites hosting databases on Windows Servers

Clients with Netsetup installation perform slow since moving to Windows Server 2019.

Connections to new Windows servers show clients take a lot longer to read the same data

Two or more processes accessing the network take less time than either process running alone when nothing else is using the network.
A remote query that returns the same result set randomly runs slower

OpenEdge Replication connection interrupts and overall latency has increased on the new Windows Server
Steps to Reproduce
Clarifying Information
Database and client startup parameters are the same.
Local installation of Client Networking did not improve performance.
Error MessageNo specific error messages
Defect Number
Enhancement Number
Cause
Several Windows Network TCP/IP features and related NIC settings are enabled, that degrade network response and overall performance. These features are typically tuned for streaming not database packets.
  • Windows Receive Side Scaling (RSS)
  • Receive Segment Coalescing (RSC) 
  • Windows Interrupt Moderation 
  • TCP Offloading
  • TCP Large Send Offload
  • Jumbo Frames/Jumbo Packets enabled devices
  • IPsec Task Offload or TCP Chimney Offload (deprecated in Windows Server 2016)
Additionally packets can be dropped when one device is not configured/does not support these features. For example TCP/IP features common for Windows Server 2019 and Windows 10 but not for earlier versions.
 
Resolution
There is no universal guidance on this topic and it is not one that technical support can necessarily assist with.

Updates from customers experiencing these client/server performance issues have reported that disabling Windows Receive Side Scaling (RSS) and Windows Interrupt Moderation on the client and Database Server machines have helped stop intermittent poor query performance.

Specific to Windows Server 2019 a default configuration change was introduced called Receive Segment Coalescing (RSC) TCP segment aggregation, that combines segments in order to process larger segments versus multiple small segments.  Customers have seen performance improvements when disabling the RSC on the driver of the network adapter of the Windows Server 2019.  This can be done as follows: 

1) Open a Powershell command prompt as Administrator
2) Run the following command:  disable-netadapterrsc *

The following VMWare Customer Connect link provides more detailed information for this work around to any performance degradation by disabling RSC:  
https://kb.vmware.com/s/article/2129176

It is recommended to engage Network specialists to assist in best resolving this according to site-specific topology.  The following forum documents these in the more recent Windows 2019 Server, which if nothing less helps to understand the complex relations of these and why they're affecting OpenEdge application network performance.
Workaround
Notes
Keyword Phrase
Last Modified Date2/14/2022 10:02 PM

Powered by