Dela via

Network Packet Size Should Not Exceed 8060 Bytes

  • Artikel

If the value specified for sp_configure 'network packet size' or if the network packet size of any logged-in user is more than 8060 bytes, SQL Server performs different memory allocation operations. This can cause an increase in the process virtual address space that is not reserved for the buffer pool.

Best Practices Recommendations

The network packet size should not exceed 8060 bytes.

For More Information

Microsoft Knowledge Base article 903002

See Also

Concepts

Monitor and Enforce Best Practices by Using Policy-Based Management