Database Reference
In-Depth Information
As discussed in
Chapter 8
,
“
Architecting for Performance: Network
,” if the network
supports larger packet sizes, increasing SQL from the default packet size of 4,096 to a
larger value can improve performance. The optimal value of the packet size for the
packet is 8192, and this is only if your network can support jumbo frames of this size,
end to end.
In the Microsoft SQL Server Management Studio, right-click
<SERVER>
and select
Properties
. On
Server Properties - <SERVER Name>
, click
Advanced
and under
Network
locate
Network Packet Size
and change this to the appropriate value, as
shown in
Figure 11.67
.
Figure 11.67
Configuring jumbo frames.
Note