topic Network Packet Size of SQL in Data Management Questions https://community.esri.com/t5/data-management-questions/network-packet-size-of-sql/m-p/303340#M17355 <HTML><HEAD></HEAD><BODY><SPAN>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?</SPAN><BR /><BR /><SPAN>Kobe</SPAN></BODY></HTML> Fri, 03 Sep 2010 19:16:15 GMT KobeHarkins 2010-09-03T19:16:15Z Network Packet Size of SQL https://community.esri.com/t5/data-management-questions/network-packet-size-of-sql/m-p/303340#M17355 <HTML><HEAD></HEAD><BODY><SPAN>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?</SPAN><BR /><BR /><SPAN>Kobe</SPAN></BODY></HTML> Fri, 03 Sep 2010 19:16:15 GMT https://community.esri.com/t5/data-management-questions/network-packet-size-of-sql/m-p/303340#M17355 KobeHarkins 2010-09-03T19:16:15Z Re: Network Packet Size of SQL https://community.esri.com/t5/data-management-questions/network-packet-size-of-sql/m-p/303341#M17356 <HTML><HEAD></HEAD><BODY><SPAN>I reset my instance to 8192K, and couldn't see difference. it could be because I don't have a well controled testing environment.</SPAN><BR /><BR /><SPAN>Robert</SPAN></BODY></HTML> Tue, 07 Sep 2010 17:42:49 GMT https://community.esri.com/t5/data-management-questions/network-packet-size-of-sql/m-p/303341#M17356 RobertHu 2010-09-07T17:42:49Z Re: Network Packet Size of SQL https://community.esri.com/t5/data-management-questions/network-packet-size-of-sql/m-p/303342#M17357 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for your reply Robert. If I see any differences I will let you know.</SPAN><BR /><BR /><SPAN>Kobe</SPAN></BODY></HTML> Mon, 13 Sep 2010 13:32:50 GMT https://community.esri.com/t5/data-management-questions/network-packet-size-of-sql/m-p/303342#M17357 KobeHarkins 2010-09-13T13:32:50Z Re: Network Packet Size of SQL https://community.esri.com/t5/data-management-questions/network-packet-size-of-sql/m-p/303343#M17358 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 14 Mar 2017 14:45:35 GMT https://community.esri.com/t5/data-management-questions/network-packet-size-of-sql/m-p/303343#M17358 ShadyKamel 2017-03-14T14:45:35Z