default network packet size configures the default packet size for all SAP ASE users.
|
Summary Information |
|
|---|---|
|
Default value |
2048 |
|
Range of values |
512– 65024 |
|
Status |
Static |
|
Display level |
Intermediate |
|
Required role |
System administrator |
|
Configuration groups |
Memory Use, Network Communication, User Environment |
You can set default network packet size to any multiple of 512 bytes; values that are not even multiples of 512 are rounded down.
Memory for all users who log in with the default packet size is allocated from the SAP ASE memory pool, as set with total logical memory. This memory is allocated for network packets when SAP ASE is started.
One read buffer
One buffer for messages
One write buffer
(number of user connections + number of worker processes) * 3 * default network packet size
For example, if you set default network packet size to 1024 bytes, and you have 50 user connections and 20 worker processes, the amount of network memory required is:
(50 + 20) * 3 * 1024 = 215040 bytes
If you increase default network packet size, you must also increase max network packet size to at least the same size. If the value of max network packet size is greater than the value of default network packet size, increase the value of additional network memory.
Use sp_sysmon to see how changing the default network packet size parameter affects network I/O management and task switching. For example, try increasing default network packet size and then checking sp_sysmon output to see how this affects bcp for large batches. See the Performance and Tuning Series: Monitoring SAP ASE with sp_sysmon.