topic ArcGIS 10.5.1 - Windows 2016 - Python to SDE - Painful Slowness! in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/arcgis-10-5-1-windows-2016-python-to-sde-painful/m-p/813195#M33606 <HTML><HEAD></HEAD><BODY><P>I have installed ArcGIS 10.5.1 on four different Windows 2016 servers.&nbsp; The 64Bit Python and 64 bit Background processing have also been installed on these machines.&nbsp; After noting what appeared to be python slowness, I have narrowed down the issue to Python that is connecting to SDE (SQL Server).&nbsp; A simple job that deletes 65k rows and then appends 65k rows from one SDE layer to another can take up-to 12min to complete.&nbsp;</P><P></P><P>The same job on my Windows 7 machine with the 64 bit libraries and ArcGIS 10.5.1 takes about 2.5 min, every time I run it.&nbsp; The same job on a windows 2012 R2 server with the 64bit libraries and ArcGIS 10.5.1 takes about 2.5 min every time.&nbsp; The Windows 2016 Servers run the code sometimes in 2.5 min but most of the time it takes greater than 8 min up-to 12 min.</P><P></P><P>I have created a support request with ESR, I hope they come back with something soon.&nbsp;</P><P></P><P>Meanwhile,&nbsp;has anyone noticed an issue with Windows 2016, Python and insert/delete of SDE layers?</P><P></P><P>Thank you.</P><P>Louie Rowley</P></BODY></HTML> Wed, 08 Nov 2017 00:24:17 GMT LouieRowley 2017-11-08T00:24:17Z ArcGIS 10.5.1 - Windows 2016 - Python to SDE - Painful Slowness! https://community.esri.com/t5/arcgis-pro-questions/arcgis-10-5-1-windows-2016-python-to-sde-painful/m-p/813195#M33606 <HTML><HEAD></HEAD><BODY><P>I have installed ArcGIS 10.5.1 on four different Windows 2016 servers.&nbsp; The 64Bit Python and 64 bit Background processing have also been installed on these machines.&nbsp; After noting what appeared to be python slowness, I have narrowed down the issue to Python that is connecting to SDE (SQL Server).&nbsp; A simple job that deletes 65k rows and then appends 65k rows from one SDE layer to another can take up-to 12min to complete.&nbsp;</P><P></P><P>The same job on my Windows 7 machine with the 64 bit libraries and ArcGIS 10.5.1 takes about 2.5 min, every time I run it.&nbsp; The same job on a windows 2012 R2 server with the 64bit libraries and ArcGIS 10.5.1 takes about 2.5 min every time.&nbsp; The Windows 2016 Servers run the code sometimes in 2.5 min but most of the time it takes greater than 8 min up-to 12 min.</P><P></P><P>I have created a support request with ESR, I hope they come back with something soon.&nbsp;</P><P></P><P>Meanwhile,&nbsp;has anyone noticed an issue with Windows 2016, Python and insert/delete of SDE layers?</P><P></P><P>Thank you.</P><P>Louie Rowley</P></BODY></HTML> Wed, 08 Nov 2017 00:24:17 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-10-5-1-windows-2016-python-to-sde-painful/m-p/813195#M33606 LouieRowley 2017-11-08T00:24:17Z Re: ArcGIS 10.5.1 - Windows 2016 - Python to SDE - Painful Slowness! https://community.esri.com/t5/arcgis-pro-questions/arcgis-10-5-1-windows-2016-python-to-sde-painful/m-p/813196#M33607 <HTML><HEAD></HEAD><BODY><P>Has ESRI certified using ArcGIS 10.5.1 on Windows 2016 Servers?</P></BODY></HTML> Wed, 08 Nov 2017 00:34:26 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-10-5-1-windows-2016-python-to-sde-painful/m-p/813196#M33607 MichaelVolz 2017-11-08T00:34:26Z Re: ArcGIS 10.5.1 - Windows 2016 - Python to SDE - Painful Slowness! https://community.esri.com/t5/arcgis-pro-questions/arcgis-10-5-1-windows-2016-python-to-sde-painful/m-p/813197#M33608 <HTML><HEAD></HEAD><BODY><P>Michael,</P><P>&nbsp; Yes they have.</P><P></P><P><A href="http://desktop.arcgis.com/en/system-requirements/latest/arcgis-desktop-system-requirements.htm#ESRI_SECTION1_4D839759F08146819E273A6DDD01DCBB">http://desktop.arcgis.com/en/system-requirements/latest/arcgis-desktop-system-requirements.htm#ESRI_SECTION1_4D839759F08146819E273A6DDD01DCBB</A></P></BODY></HTML> Wed, 08 Nov 2017 00:44:04 GMT https://community.esri.com/t5/arcgis-pro-questions/arcgis-10-5-1-windows-2016-python-to-sde-painful/m-p/813197#M33608 LouieRowley 2017-11-08T00:44:04Z