topic Re: SQL Server Enterprise Geodatabase slow performance with M values? in Roads and Highways Questions https://community.esri.com/t5/roads-and-highways-questions/sql-server-enterprise-geodatabase-slow-performance/m-p/877909#M310 <HTML><HEAD></HEAD><BODY><P>OK, not exactly what we discovered but will toss it out there for you as an option to consider. In this other post I gave the link to original post where I broke down details regarding modification of the disc storage drive configurations used behind the scenes of SQL Server. While this may not fix this issue for you I'd still suggest checking it out as it's proven to provide significant performance gains for us and many others using SQL.</P><P></P><P><A _jive_internal="true" href="https://community.esri.com/thread/200309-system-design-strategies-and-performance">https://community.esri.com/thread/200309-system-design-strategies-and-performance</A></P></BODY></HTML> Fri, 21 Sep 2018 13:33:08 GMT ScottFierro2 2018-09-21T13:33:08Z SQL Server Enterprise Geodatabase slow performance with M values? https://community.esri.com/t5/roads-and-highways-questions/sql-server-enterprise-geodatabase-slow-performance/m-p/877904#M305 <HTML><HEAD></HEAD><BODY><P>Has anyone seen performance issues when using SQL Server Esri Enterprise Geodatabase with data that have M values. We are running across slow draw times on all of our GIS datasets that were derived from our LRS network GIS layer. The same datasets will draw within 1 second in a file geodatabase vs in sql will take 10-15 seconds.&nbsp;</P><P>Thanks,</P><P>Claire</P></BODY></HTML> Thu, 20 Sep 2018 17:41:24 GMT https://community.esri.com/t5/roads-and-highways-questions/sql-server-enterprise-geodatabase-slow-performance/m-p/877904#M305 ClaireInbody1 2018-09-20T17:41:24Z Re: SQL Server Enterprise Geodatabase slow performance with M values? https://community.esri.com/t5/roads-and-highways-questions/sql-server-enterprise-geodatabase-slow-performance/m-p/877905#M306 <HTML><HEAD></HEAD><BODY><P>No, not from my experience.&nbsp; There are many other potential issues that may be affecting your performance.&nbsp; I would recommend logging a case with Esri technical support so they can work with you to track down the root cause(s).&nbsp;</P></BODY></HTML> Fri, 21 Sep 2018 12:43:20 GMT https://community.esri.com/t5/roads-and-highways-questions/sql-server-enterprise-geodatabase-slow-performance/m-p/877905#M306 CliveReece 2018-09-21T12:43:20Z Re: SQL Server Enterprise Geodatabase slow performance with M values? https://community.esri.com/t5/roads-and-highways-questions/sql-server-enterprise-geodatabase-slow-performance/m-p/877906#M307 <HTML><HEAD></HEAD><BODY><P>Thanks Clive. I have already started a ticket with Esri. Still trying to track down the performance issue.&nbsp;</P></BODY></HTML> Fri, 21 Sep 2018 12:48:03 GMT https://community.esri.com/t5/roads-and-highways-questions/sql-server-enterprise-geodatabase-slow-performance/m-p/877906#M307 ClaireInbody1 2018-09-21T12:48:03Z Re: SQL Server Enterprise Geodatabase slow performance with M values? https://community.esri.com/t5/roads-and-highways-questions/sql-server-enterprise-geodatabase-slow-performance/m-p/877907#M308 <HTML><HEAD></HEAD><BODY><P>Is this issue specific to only feature classes which have M values or do you experience the same slowness with other feature classes that don't have M values?</P><P>What version of SQL Server are you using?</P></BODY></HTML> Fri, 21 Sep 2018 13:06:59 GMT https://community.esri.com/t5/roads-and-highways-questions/sql-server-enterprise-geodatabase-slow-performance/m-p/877907#M308 ScottFierro2 2018-09-21T13:06:59Z Re: SQL Server Enterprise Geodatabase slow performance with M values? https://community.esri.com/t5/roads-and-highways-questions/sql-server-enterprise-geodatabase-slow-performance/m-p/877908#M309 <HTML><HEAD></HEAD><BODY><P>We are seeing it only on feature classes with M values. SQL Server version 2016.&nbsp;</P></BODY></HTML> Fri, 21 Sep 2018 13:12:39 GMT https://community.esri.com/t5/roads-and-highways-questions/sql-server-enterprise-geodatabase-slow-performance/m-p/877908#M309 ClaireInbody1 2018-09-21T13:12:39Z Re: SQL Server Enterprise Geodatabase slow performance with M values? https://community.esri.com/t5/roads-and-highways-questions/sql-server-enterprise-geodatabase-slow-performance/m-p/877909#M310 <HTML><HEAD></HEAD><BODY><P>OK, not exactly what we discovered but will toss it out there for you as an option to consider. In this other post I gave the link to original post where I broke down details regarding modification of the disc storage drive configurations used behind the scenes of SQL Server. While this may not fix this issue for you I'd still suggest checking it out as it's proven to provide significant performance gains for us and many others using SQL.</P><P></P><P><A _jive_internal="true" href="https://community.esri.com/thread/200309-system-design-strategies-and-performance">https://community.esri.com/thread/200309-system-design-strategies-and-performance</A></P></BODY></HTML> Fri, 21 Sep 2018 13:33:08 GMT https://community.esri.com/t5/roads-and-highways-questions/sql-server-enterprise-geodatabase-slow-performance/m-p/877909#M310 ScottFierro2 2018-09-21T13:33:08Z