Network Packet Size of SQL

783
3
09-03-2010 12:16 PM
KobeHarkins
New Contributor
I was reading how ArcSDE, by default, sets the network packet size to 8,192k. This setting can also be made global to SQL Server. Has anyone changed this setting is SQL and did you see a difference in performance of your GIS databases?

Kobe
0 Kudos
3 Replies
RobertHu
New Contributor II
I reset my instance to 8192K, and couldn't see difference. it could be because I don't have a well controled testing environment.

Robert
0 Kudos
KobeHarkins
New Contributor
Thanks for your reply Robert. If I see any differences I will let you know.

Kobe
0 Kudos
ShadyKamel
New Contributor II

this configuration does not depends on the SDE or SQL Server only. The network infrastructure must support transferring large packets also at the intermediate network devices (Switches, routers, Firewalls. for example if the network device support packets size 1024 B (which is the default) large packets will be divided at the network level hence transfer the performance issue to the network and make it candidate for packet loss. so take care to test the packet size configuration first on your network.

0 Kudos