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?
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.
