Summary information |
|
|---|---|
Default value |
512 |
Range of values |
512–32768 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration group |
Component Integration Services |
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.
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.
If you specify a packet size larger than the default, then the target server must be configured to allow variable-length packet sizes, using:
additional netmem
maximum network packet size
