How can SolarWinds DPA be used to improve GIS applications accessing a SQL database?

Question

How have users of SolarWinds database performance analyzer been able to improve the end-user experience of GIS applications (ArcMap for starters) accessing SQL Server databases?  If a SQL query has been determined to be taking too long and hardware is not the issue, how can they be altered?

ThomasColson · Answer

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.