Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SP_Configure Network Packet Size

Author  Topic 

srinivasb
Starting Member

1 Post

Posted - 2011-05-31 : 03:32:31
Hi,

Links from BOL

Network Packet Size Max Value : 32767
[url]http://msdn.microsoft.com/en-us/library/ms189631.aspx[/url]


Network Packet Size Should Not Exceed 8060 Bytes
[url]http://msdn.microsoft.com/en-us/library/bb402885%28v=sql.100%29.aspx[/url]


Which is the best value for Net Work Packet size w.R.To Performance?

Thanks,
Srinivas
   

- Advertisement -