Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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. 

  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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.