topic How can SolarWinds DPA be used to improve GIS applications accessing a SQL database? in Developers Questions https://community.esri.com/t5/developers-questions/how-can-solarwinds-dpa-be-used-to-improve-gis/m-p/681219#M4677 <HTML><HEAD></HEAD><BODY><P>How have users of SolarWinds database performance analyzer been able to improve the&nbsp;end-user experience of GIS applications (ArcMap for starters)&nbsp;accessing SQL Server databases?&nbsp; If a SQL query has been determined to be taking too long and hardware is not the issue, how can they be altered?</P></BODY></HTML> Wed, 16 Nov 2016 16:03:34 GMT ZacheryBettis 2016-11-16T16:03:34Z How can SolarWinds DPA be used to improve GIS applications accessing a SQL database? https://community.esri.com/t5/developers-questions/how-can-solarwinds-dpa-be-used-to-improve-gis/m-p/681219#M4677 <HTML><HEAD></HEAD><BODY><P>How have users of SolarWinds database performance analyzer been able to improve the&nbsp;end-user experience of GIS applications (ArcMap for starters)&nbsp;accessing SQL Server databases?&nbsp; If a SQL query has been determined to be taking too long and hardware is not the issue, how can they be altered?</P></BODY></HTML> Wed, 16 Nov 2016 16:03:34 GMT https://community.esri.com/t5/developers-questions/how-can-solarwinds-dpa-be-used-to-improve-gis/m-p/681219#M4677 ZacheryBettis 2016-11-16T16:03:34Z Re: How can SolarWinds DPA be used to improve GIS applications accessing a SQL database? https://community.esri.com/t5/developers-questions/how-can-solarwinds-dpa-be-used-to-improve-gis/m-p/681220#M4678 <HTML><HEAD></HEAD><BODY><P>I'd run SQL Profiler and Tuner to see where your query/index bottle necks are. I've found that the out of the box indexes that are created with a new feature class are often 100% of the cause of slow performing queries, and you need to tune the indexes, especially spatial.&nbsp;</P></BODY></HTML> Tue, 06 Jun 2017 15:41:00 GMT https://community.esri.com/t5/developers-questions/how-can-solarwinds-dpa-be-used-to-improve-gis/m-p/681220#M4678 ThomasColson 2017-06-06T15:41:00Z