Useful database monitoring tool
June 03, 2019
Useful database monitoring tool
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with SolarWinds Database Performance Analyzer
The primary purpose that we use Database Performance Analyzer for is to monitor database instances. We also use it for Query performance analysis. We also use it for performance analysis. For our application, we monitor primarily the index advisory/recommendations.
- We use this software to identify real-time performance problems such as errors, long-running queries or problems that are blocking the system.
- We use this software to review previous SQL Server queries/performance.
- When there is an issue with any Server and I need to quickly narrow down to the right place of the root cause, this is a tool that allows me to focus on the right places and remove all sorts of noise from our data.
- Cannot easily find a query using a "text search" without detailed knowledge of the underlying SQL database "repository" that is used to display the data in each product.
- On the ad-hoc plan tab, for any given plan we have to drill down each SQL manually one by one. It would be goOd to have some kind of summary popup/tool-tip when we hover over the plan in DPA.
- I/O activity tracking at the drive/mount and file level - this helps to plan for better storage devices.
- Correlated resource metrics for easy diagnosis of hardware constraint impacts on end-users.