topic Re: SQL Server 2012 and 2008: Geometry Performance in Data Management Questions https://community.esri.com/t5/data-management-questions/sql-server-2012-and-2008-geometry-performance/m-p/395607#M22679 <HTML><HEAD></HEAD><BODY><P>SQL 2012 introduced autogrid (with 8 levels), but legacy SDE spatial tables will still use the 4-level index unless you specifically recreate the index. I've found that starting with 1024 cells with autogrid is worth at least a 10% increase in draw times for large tables. </P></BODY></HTML> Fri, 27 Nov 2015 15:55:15 GMT ThomasColson 2015-11-27T15:55:15Z SQL Server 2012 and 2008: Geometry Performance https://community.esri.com/t5/data-management-questions/sql-server-2012-and-2008-geometry-performance/m-p/395606#M22678 <HTML><HEAD></HEAD><BODY><SPAN>Hello-</SPAN><BR /><SPAN>Has anyone experienced increased I/O performance with SQL Server 2012 vs. 2008 when using Sql Geometry?&nbsp; We have found that by modifying the default spatail index from: Medium for all four levels with 16 cells per object, to Medium for levels 1-3, Low for Level 4 with 64 cells per object significantly increased draw speeds since 10.1 for large complex layers such as Parcels and have been using this index ever since.&nbsp; </SPAN><BR /><BR /><SPAN>Does anyone know if the SQL Server 2012 daatabase engine handles Sql Geometry more efficiently?&nbsp; Our sde currently resindes on a Windows Server 2008R2 with 16 cores (no hyperthreading!) and 64-gb of RAM with a RAID 10 configuration.</SPAN><BR /><SPAN>Thanks</SPAN><BR /><SPAN>David</SPAN></BODY></HTML> Mon, 30 Jun 2014 15:16:42 GMT https://community.esri.com/t5/data-management-questions/sql-server-2012-and-2008-geometry-performance/m-p/395606#M22678 DavidColey 2014-06-30T15:16:42Z Re: SQL Server 2012 and 2008: Geometry Performance https://community.esri.com/t5/data-management-questions/sql-server-2012-and-2008-geometry-performance/m-p/395607#M22679 <HTML><HEAD></HEAD><BODY><P>SQL 2012 introduced autogrid (with 8 levels), but legacy SDE spatial tables will still use the 4-level index unless you specifically recreate the index. I've found that starting with 1024 cells with autogrid is worth at least a 10% increase in draw times for large tables. </P></BODY></HTML> Fri, 27 Nov 2015 15:55:15 GMT https://community.esri.com/t5/data-management-questions/sql-server-2012-and-2008-geometry-performance/m-p/395607#M22679 ThomasColson 2015-11-27T15:55:15Z