Summary information |
|
|---|---|
Default value |
0 |
Range of values |
0–2147483647 |
Status |
Dynamic |
Display level |
Intermediate |
Required role |
System Administrator |
additional network memory sets the maximum size of additional memory that can be used for network packets that are larger than the default packet size. Adaptive Server rounds down the value you enter to the nearest 2K value. The default value indicates that no extra space is allocated for large packets.
If you increase max network packet size but do not increase additional network memory, clients cannot use packet sizes that are larger than the default size, because all allocated network memory is reserved for users at the default size. Adaptive Server guarantees that every user connection can log in at the default packet size. In this situation, users who request a large packet size when they log in receive a warning message telling them that their application will use the default size.
Increasing additional network memory may improve performance for applications that transfer large amounts of data. To determine the value for additional network memory when your applications use larger packet sizes:
Estimate the number of simultaneous users who will request the large packet sizes, and the sizes their applications will request,
Multiply this sum by three, since each connection needs three buffers,
Add two percent for overhead, and
Round the value to the next highest multiple of 2048.
For example, if you estimate these simultaneous needs for larger packet sizes:
Application |
Packet size |
Overhead |
|---|---|---|
bcp |
8192 |
|
Client-Library |
8192 |
|
Client-Library |
4096 |
|
Client-Library |
4096 |
|
Total |
24576 |
|
Multiply by 3 buffers/user |
* 3=73728 |
|
Compute 2% overhead |
* .02=1474 |
|
Add overhead |
+ 1474 |
|
Additional network memory |
75202 |
|
Round up to multiple of 2048 |
75776 |
You should set additional network memory to 75,776 bytes.
