https://community.esri.com/t5/arcgis-enterprise-questions/support-of-memory-optimized-table-on-microsoft-sql/m-p/1120450#M31686 <P>Hi</P><P>We are researching about using memory-optimized table on Microsoft SQL Server for Enterprise Geo-Database for OLTP use. But memory-optimized table has some constraints, like it requires the database to disable auto-close feature. I need to find a way to enable the memory optimized status for spatial layers. I am considering if it's needed to join memory-optimized non-geometry table with spatial layers in table design.</P><P>In fact, is there any information related to use of memory-optimized table for Enterprise Geo-Database is available online?&nbsp;</P><P>Thanks</P> Fri, 26 Nov 2021 15:49:52 GMT WilliamYip 2021-11-26T15:49:52Z https://community.esri.com/t5/arcgis-enterprise-questions/support-of-memory-optimized-table-on-microsoft-sql/m-p/1120450#M31686 <P>Hi</P><P>We are researching about using memory-optimized table on Microsoft SQL Server for Enterprise Geo-Database for OLTP use. But memory-optimized table has some constraints, like it requires the database to disable auto-close feature. I need to find a way to enable the memory optimized status for spatial layers. I am considering if it's needed to join memory-optimized non-geometry table with spatial layers in table design.</P><P>In fact, is there any information related to use of memory-optimized table for Enterprise Geo-Database is available online?&nbsp;</P><P>Thanks</P> Fri, 26 Nov 2021 15:49:52 GMT https://community.esri.com/t5/arcgis-enterprise-questions/support-of-memory-optimized-table-on-microsoft-sql/m-p/1120450#M31686 WilliamYip 2021-11-26T15:49:52Z