topic Re: SQL Server (for SDE Enterprise GDB) Configuration Keywords- Help in Data Management Questions https://community.esri.com/t5/data-management-questions/sql-server-for-sde-enterprise-gdb-configuration/m-p/35846#M2009 <HTML><HEAD></HEAD><BODY><P>Hello Joe,</P><P>We used to do that sort of configuration back in the old ArcSDE days.</P><P>With everything now virtual and running on SAN hardware, the idea of tuning to specific table spaces for Oracle's /u01, /u02 and so on has been handed over to those tiers auto-tuning algorithms and SQL Server/ArcSDE defaults.</P><P>-Bill</P></BODY></HTML> Fri, 17 Mar 2017 00:59:28 GMT BillFox 2017-03-17T00:59:28Z SQL Server (for SDE Enterprise GDB) Configuration Keywords- Help https://community.esri.com/t5/data-management-questions/sql-server-for-sde-enterprise-gdb-configuration/m-p/35845#M2008 <HTML><HEAD></HEAD><BODY><P>I stumbled across an article the other day that mentioned the configuration of a SQL Server keyword parameters and how Arc Catalog will let you export the configs/ edit them and then import them.&nbsp;</P><P></P><P>I have 0 experience working with this and I am wondering what the benefit of doing this will be? I have the SDE Keyword Configs exported to a .txt file and not sure if it can be improved at all. I am referencing this:</P><P>&nbsp;<A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/configuration-parameters-sqlserver.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/configuration-parameters-sqlserver.htm">SQL Server configuration parameters—Help | ArcGIS Desktop</A>&nbsp;</P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/export-geodatabase-configuration-keywords.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/export-geodatabase-configuration-keywords.htm">Export Geodatabase Configuration Keywords—Help | ArcGIS for Desktop</A>&nbsp;</P><P></P><P>Our data is updated/edited I would say somewhat often (Local Municipality) so residents info changes, building info changes etc... so our fillfactor is currently at 75.</P><P></P><P>Other than that I do not know where to begin. Is there anyone who has done this before who would have some insight or an example 'optimum' &nbsp;config file I could reference?</P></BODY></HTML> Thu, 16 Mar 2017 14:17:26 GMT https://community.esri.com/t5/data-management-questions/sql-server-for-sde-enterprise-gdb-configuration/m-p/35845#M2008 Lake_Worth_BeachAdmin 2017-03-16T14:17:26Z Re: SQL Server (for SDE Enterprise GDB) Configuration Keywords- Help https://community.esri.com/t5/data-management-questions/sql-server-for-sde-enterprise-gdb-configuration/m-p/35846#M2009 <HTML><HEAD></HEAD><BODY><P>Hello Joe,</P><P>We used to do that sort of configuration back in the old ArcSDE days.</P><P>With everything now virtual and running on SAN hardware, the idea of tuning to specific table spaces for Oracle's /u01, /u02 and so on has been handed over to those tiers auto-tuning algorithms and SQL Server/ArcSDE defaults.</P><P>-Bill</P></BODY></HTML> Fri, 17 Mar 2017 00:59:28 GMT https://community.esri.com/t5/data-management-questions/sql-server-for-sde-enterprise-gdb-configuration/m-p/35846#M2009 BillFox 2017-03-17T00:59:28Z