cis packet size

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.

If you specify a packet size larger than the default, then the target server must be configured to allow variable-length packet sizes, using:

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.