We have noticed that there isn’t much information available online about adjusting SQL Server Network Packet Sizes. Even Microsoft suggests that the default value of 4096 is the best option for most applications. We believe the default value is an artifact catering to lower connection speeds and applications.
However, the Nitrosphere team is committed to enhancing network performance, and we have found that modifying the SQL Server Packet Size can often be a quick and effective solution to improve network performance. When setting up or optimizing a server, this is one of the first configurations we make, and the best part is that you don’t need to restart the server afterward.
Packet sizes are automatically negotiated for each connection, so increasing the value on your SQL Server will reduce query times and improve application performance where it can without forcing larger packet sizes onto legacy applications that will continue to negotiate within their existing parameters.
To increase the SQL Server Network Packet Size, you can follow these steps:
- Open SQL Server Configuration Manager. You can find it in the Start menu under “Microsoft SQL Server” folder.
- Expand “SQL Server Network Configuration” and select “Protocols for [instance name]”.
- Right-click on “TCP/IP” protocol and select “Properties”.
- In the “Protocol” tab, scroll down to find “Network Packet Size” and change the value to the packet size to 32000. For TLS, set the value to 16000.
- Click “OK” to save the changes.
- Restart the SQL Server service for the changes to take effect.
As with any alteration in settings, we recommend monitoring the improvements in performance, especially with older hardware or software. Keep in mind that if the application requires a smaller packet size, it will simply negotiate that lower value automatically.
Increasing the network packet size will benefit your network even if you are not running our SQL Server Connection Acceleration Software, so we recommend making the change right away.
This performance improvement tip will alleviate network performance issues by adding more data to each packet that moves across the connection. If you are looking to improve the advantage provided by 2-12x, we recommend taking a look at our endpoint-based acceleration software. Much like the packet size increase process above, the solution will improve query and application performance. However, it does not require a server restart to begin testing.
“Nitrosphere’s solution is simple, but highly effective.” – Gluesoft