Large network packet size

• RockingAdmin

  SSCrazy

  Points: 2828

  More actions

  August 21, 2014 at 4:11 pm

  #298694

  Hi,

  I noticed couple of sessions with a larger network packet size of 32764 while investigating the performance issues on a SQL Server2008 R2(windows 2008). the network size(default) was set to 4096 bytes but why sql server is accepting a higher packets? Does the default size will work only for sql server out flow packets? Is this expected or should be fixed?

  Please advise me some recommendations to tune.

  Thanks

  Rocky.

• Perry Whittle

  SSC Guru

  Points: 233858

  More actions

  August 26, 2014 at 6:13 am

  #1740993

  packet size can be set at the client level also

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉