Network Packet Size of SQL

[KobeHarkins]

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

[RobertHu]

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

[KobeHarkins]

Thanks for your reply Robert. If I see any differences I will let you know.

Kobe

[ShadyKamel]

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.