Microsoft® SQL Server 2012 Unleashed

network packet size

Type: Basic

Default value: 4096

The network packet size parameter specifies the default network packet size for SQL Server. Setting this value to a higher number (which should be divisible by 512) can improve the performance of applications that involve a large amount of data transfer from the server. Check your network configuration and set an appropriate value for this parameter. You can also improve performance by lowering the size value for applications that are small in data transfer size. However, the usual scenario is to increase this size to accommodate large amounts of data transfer, as with bulk loads.

The following is an example of this option:

Click here to view code image

exec sp_configure 'network packet size', ...