topic Re: GeoDB/DBMS tuning in Data Management Questions https://community.esri.com/t5/data-management-questions/geodb-dbms-tuning/m-p/32056#M1738 <HTML><HEAD></HEAD><BODY><SPAN>That article is pretty dated - it appears to have been written for much older versions of ArcGIS and SQL Server.</SPAN><BR /><BR /><SPAN>There is really nothing specific to do for SQL Server 2012, other than make sure you apply both ArcGIS 10.1 SP1 and SQL Server 2012 SP1. As it is a new release the first few service packs are useful to apply.</SPAN><BR /><BR /><SPAN>The standard geodatabase maintenance tasks apply - maintain statistics, rebuild indexes if the data is changing a lot, and compress regularly.</SPAN><BR /><BR /><SPAN>And the standard SQL Server tasks apply as well - make sure you have a sound backup and recovery plan, make sure you size your database and logfiles appropriately and do not rely on small autogrowth increments, and keep tempdb on a separate disk if possible.</SPAN><BR /><BR /><SPAN>-Shannon</SPAN></BODY></HTML> Mon, 19 Nov 2012 22:43:04 GMT ShannonShields 2012-11-19T22:43:04Z GeoDB/DBMS tuning https://community.esri.com/t5/data-management-questions/geodb-dbms-tuning/m-p/32054#M1736 <HTML><HEAD></HEAD><BODY><SPAN style="font-family:Book Antiqua;">What is the recommended standard tuning needed to be done on a geodatabase on SQL Server 2012 for direct connection or two-tier topology? </SPAN></BODY></HTML> Mon, 19 Nov 2012 03:46:18 GMT https://community.esri.com/t5/data-management-questions/geodb-dbms-tuning/m-p/32054#M1736 AlaaKutbi 2012-11-19T03:46:18Z Re: GeoDB/DBMS tuning https://community.esri.com/t5/data-management-questions/geodb-dbms-tuning/m-p/32055#M1737 <HTML><HEAD></HEAD><BODY><SPAN>Hi Alaa,</SPAN><BR /><BR /><SPAN>This is an older doc, but some of its contents are still applicable:</SPAN><BR /><A href="http://support.esri.com/en/knowledgebase/techarticles/detail/25040"><BR />KB #25040 - FAQ: What are some common ArcSDE SQL Server tuning tasks?</A><BR /><BR /><SPAN>Hope this helps,</SPAN></BODY></HTML> Mon, 19 Nov 2012 15:40:51 GMT https://community.esri.com/t5/data-management-questions/geodb-dbms-tuning/m-p/32055#M1737 DerekLaw 2012-11-19T15:40:51Z Re: GeoDB/DBMS tuning https://community.esri.com/t5/data-management-questions/geodb-dbms-tuning/m-p/32056#M1738 <HTML><HEAD></HEAD><BODY><SPAN>That article is pretty dated - it appears to have been written for much older versions of ArcGIS and SQL Server.</SPAN><BR /><BR /><SPAN>There is really nothing specific to do for SQL Server 2012, other than make sure you apply both ArcGIS 10.1 SP1 and SQL Server 2012 SP1. As it is a new release the first few service packs are useful to apply.</SPAN><BR /><BR /><SPAN>The standard geodatabase maintenance tasks apply - maintain statistics, rebuild indexes if the data is changing a lot, and compress regularly.</SPAN><BR /><BR /><SPAN>And the standard SQL Server tasks apply as well - make sure you have a sound backup and recovery plan, make sure you size your database and logfiles appropriately and do not rely on small autogrowth increments, and keep tempdb on a separate disk if possible.</SPAN><BR /><BR /><SPAN>-Shannon</SPAN></BODY></HTML> Mon, 19 Nov 2012 22:43:04 GMT https://community.esri.com/t5/data-management-questions/geodb-dbms-tuning/m-p/32056#M1738 ShannonShields 2012-11-19T22:43:04Z