topic Re: SQL Server not using spatial indexes for ArcGISDynamicMapServiceLayer requests in ArcGIS JavaScript Maps SDK Questions https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/sql-server-not-using-spatial-indexes-for/m-p/64709#M5664 <HTML><HEAD></HEAD><BODY><P>You might find some answers if you post it in the right forum. This forum is for JavaScript API queries.</P></BODY></HTML> Fri, 20 May 2016 14:32:42 GMT thejuskambi 2016-05-20T14:32:42Z SQL Server not using spatial indexes for ArcGISDynamicMapServiceLayer requests https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/sql-server-not-using-spatial-indexes-for/m-p/64708#M5663 <HTML><HEAD></HEAD><BODY><P><BR />I have a Windows Server 2012 R2 running SQL Server 2012 R2 and ESRI Server 10.3.&nbsp; The server has 16 dual-core Xeon processors and 96 GB of RAM.&nbsp; I have a web application that is using ArcGISDynamicMapServiceLayers to display state-wide lines and points, including labels for both lines and points.&nbsp; We restrict the display of the lines/points until the user is zoomed to an appropriate level.</P><P></P><P>The issue that we are seeing is every time the web application requests data, the SQL Server CPU load goes to 100%.&nbsp; When one user is using the application performance is not bad, but when several folks start using it performance degrades quickly.&nbsp; </P><P></P><P>In analyzing the queries that are being used, it doesn't appear that SQL Server is using the spatial indexes at all.&nbsp; I've tried several things, including setting MAXDOP to 1, but nothing seems to work and SQL Server takes the CPU to 100% every time the application requests data.&nbsp; </P><P></P><P>Has anyone experienced this issue and been able to find a resolution?</P></BODY></HTML> Fri, 20 May 2016 14:17:04 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/sql-server-not-using-spatial-indexes-for/m-p/64708#M5663 SteveBurdette 2016-05-20T14:17:04Z Re: SQL Server not using spatial indexes for ArcGISDynamicMapServiceLayer requests https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/sql-server-not-using-spatial-indexes-for/m-p/64709#M5664 <HTML><HEAD></HEAD><BODY><P>You might find some answers if you post it in the right forum. This forum is for JavaScript API queries.</P></BODY></HTML> Fri, 20 May 2016 14:32:42 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/sql-server-not-using-spatial-indexes-for/m-p/64709#M5664 thejuskambi 2016-05-20T14:32:42Z Re: SQL Server not using spatial indexes for ArcGISDynamicMapServiceLayer requests https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/sql-server-not-using-spatial-indexes-for/m-p/64710#M5665 <HTML><HEAD></HEAD><BODY><P>I posted in both the Javascript API and ArcGIS Server forums.&nbsp; I figured there were some developers that had run across this issue as well and might have some input.</P></BODY></HTML> Fri, 20 May 2016 17:39:35 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/sql-server-not-using-spatial-indexes-for/m-p/64710#M5665 SteveBurdette 2016-05-20T17:39:35Z