Overall Satisfaction with SolarWinds Database Performance Analyzer
DPA at Reliance is used within the IT department only. We monitor the performance of SQL queries as well as to see if we have any issues with the resources. I use the information provided by DPA to optimize the worst performing queries. I concentrate on instances with highest wait time and SQL with the highest percentage of instance execution time. We also use DPA to check for blocking and deadlocks.
- DPA tells you if there are missing indexes.
- DPA gives you predicate warnings for SQL queries.
- DPA monitors main resource performance counters for the VM and host and also read and write latencies for data partitions.
- We DBAs often don't have enough insight into the type of hardware being used. For example I'd like to know if our SAN presents new pages as pre-initialized or the operating system re-initialize the pages.
- I'd like to be able to see in DPA if our infrastructure performs physical file fragmentation on our SAN.
- I would like to see IO blocks size that was used for SQL Server and other internals from infrastructure side that we DBAs don't have visibility.
- We are very satisfied with the product. SolarWinds DPA has had a positive impact on our business objectives.