Skip to content

Latest commit

 

History

History
29 lines (24 loc) · 1.3 KB

File metadata and controls

29 lines (24 loc) · 1.3 KB
title Network Packet Size Should Not Exceed 8060 Bytes | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology security
ms.topic conceptual
helpviewer_keywords
Best Practices [Database Engine]
ms.assetid 86db5da1-afe4-4fbb-8bf8-33cedc7e4361
author VanMSFT
ms.author vanto

Network Packet Size Should Not Exceed 8060 Bytes

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] 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, [!INCLUDEssNoVersion] 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

Monitor and Enforce Best Practices by Using Policy-Based Management