The Receive Window Auto-Tuning feature lets the operating system continually monitor routing conditions such as bandwidth, network delay, and application delay. Therefore, the operating system can configure connections by scaling the TCP receive window to maximize the network performance. To determine the optimal receive window size, the Receive Window Auto-Tuning feature measures the products that delay bandwidth and the application retrieve rates. Then, the Receive Window Auto-Tuning feature adapts the receive window size of the ongoing transmission to take advantage of any unused bandwidth.
While the feature may improve speed, in some cases it can also cause problems and slow down the network.
Music Auto Tuning
Automatic tuning in SQL Server 2017 enables the identification and correction of performance issues caused by SQL Server plan choice regression. The database engine monitors the queries that are executed on the database and automatically improves the performance of the workload. And a bug found in Windows: It is very clear that when Windows was asked to display the current 'Receive Window Auto-Tuning Level' and Windows said 'normal' and claimed that 'is the result of Windows Scaling heuristics overriding any local/policy configuration on at least one profile'- that Windows displayed the wrong mode, and should have.
To disable the feature, use this command:
To see if the feature is enabled or disabled, use this command:
To enable the Receive Window Auto-Tuning Level, use this command:
Here’s a list of available options for the autotuning parameter:
What Is Windows Auto Tuning Level 6
disabled: Fix the receive window at its default value.
highlyrestricted: Allow the receive window to grow beyond its default value, but do so very conservatively.
restricted: Allow the receive window to grow beyond its default value, but limit such growth in some scenarios.
normal: Allow the receive window to grow to accommodate almost all scenarios.
experimental: Allow the receive window to grow to accommodate extreme scenarios. WARNING: This can dramatically degrade performance in common scenarios and should only be used for research purposes.
highlyrestricted: Allow the receive window to grow beyond its default value, but do so very conservatively.
restricted: Allow the receive window to grow beyond its default value, but limit such growth in some scenarios.
normal: Allow the receive window to grow to accommodate almost all scenarios.
experimental: Allow the receive window to grow to accommodate extreme scenarios. WARNING: This can dramatically degrade performance in common scenarios and should only be used for research purposes.