What is our primary use case?
The primary use cases involve identifying database performance issues, such as long-running queries, wait times, deadlocks, and other read-and-write performance-related issues.
Long-running queries are particularly common, and customers find the tool useful for pinpointing such issues.
What needs improvement?
There's room for improvement on the dashboarding side. Specifically, the health dashboard of the database instances. Some of my customers deal with a large number of monitored database instances.
It would be beneficial if they could have a single dashboard for instances, for example, from number one to thirty. This way, I could monitor all these 30 instances and quickly identify any performance issues on any of them. The dashboarding capability definitely needs improvement.
In future releases, there should be custom reports and dashboards are crucial. Not everyone needs to see the same page every time. For example, if I'm interested in MYSQL databases, I should have a view that focuses only on MYSQL databases. Customization like this, where users can tailor their dashboards to specific needs, is essential for improving the product.
For how long have I used the solution?
I have been using this solution for more than a year.
What do I think about the stability of the solution?
It is a pretty stable product.
What do I think about the scalability of the solution?
It is scalable. In my current environment, I haven't faced challenges in adding more instances for monitoring.
The solution is usually highly recommended for larger enterprises. Large companies often face challenges with database administrators struggling to manage a large number of database instances. So, they could benefit from using this product.
For smaller setups, a tool may still be valuable, especially if they have a few database instances to monitor. They might manage with native tools like MSSQL Management Studio, which can provide indications if not detailed, performance statistics. However, the significant benefit of this tool is realized more by larger organizations
How are customer service and support?
The initial support (Level 1) might struggle with DPA issues, but escalated cases receive proper support. There is room for improvement in Level 1 support.
How would you rate customer service and support?
Which solution did I use previously and why did I switch?
We exclusively work with SolarWinds for database monitoring.
How was the initial setup?
The initial setup is pretty straightforward. The best part is that SolarWinds Database Performance Analyzer (DPA) can be used as a standalone tool or integrated seamlessly with other SolarWinds tools. For instance, it can integrate with server and application monitoring.
DPA is a specialized tool for databases, while server and application monitoring is a generic tool for all applications, including databases
What about the implementation team?
We mainly deploy the SolarWinds stack for our customers.
What's my experience with pricing, setup cost, and licensing?
The pricing is fairly reasonable, and it becomes more cost-effective with larger volumes of instances.
Maintenance support is included for the first year, and subsequent years require payment for software and subscriptions.
What other advice do I have?
I would suggest carefully charting out critical database instances and figuring out if the user is facing application slowness issues. If yes, they should first use simple server and application monitoring to determine whether the issues lie outside the database or within. It could be an underlying storage, server, or network-related problem.
To pinpoint network or server-related issues it can get complex. There could be physical server issues, virtual server issues, host layer problems, or underlying storage or SAN environment concerns, if they have any.
Overall, I would rate the solution an eight out of ten. The areas where it currently lags are in reporting and dashboarding. The reports and dashboards are somewhat static, and we cannot create custom dashboards for specific customer needs.
*Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller