cis packet size specifies the size of Tabular Data Stream™ (TDS) packets that are exchanged between the server and a remote server when a connection is initiated.
|
Summary Information |
|
|---|---|
|
Default value |
512 |
|
Range of values |
512–32768 |
|
Status |
Dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
Component Integration Services |
The default packet size on most systems is 512 bytes, and this may be adequate for most applications. However, larger packet sizes may result in significantly improved query performance, especially when text, unitext, and image or bulk data is involved.
additional netmem
maximum network packet size
If you specify a packet size on the target server that is smaller than the default, it uses the default packet size instead of the cis packet size.