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.

Community Additions