The network packet size option sets the packet size (in bytes) that is used across the whole network. Packets are the fixed-size chunks of data that transfer requests and results between clients and servers. The default packet size is 4,096 bytes.

Note:

Do not change the packet size unless you are certain that it will improve performance. For most applications, the default packet size is best.

-- Check network packet size
Select *
From sys.configurations
Where name = 'network packet size (B)';

Sources:

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-network-packet-size-server-configuration-option?view=sql-server-ver15

Last modified: December 30, 2019

Author

Comments

Write a Reply or Comment