Export (0) Print
Expand All
Expand Minimize

How to: Configure Packet Size (SQL Server Management Studio)

Use the network packet size option to set the packet size (in bytes) used across the entire network. Packets are the fixed-size chunks of data that transfer requests and results between clients and servers. The default packet size set by Microsoft SQL Server is 4,096 bytes. 

To configure packet size

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Advanced node.

  3. Under Network, select a value for the Network Packet Size box.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft