HPE Nimble Storage vs. SolarWinds Database Performance Analyzer

HPE Nimble Hybrid storage is very cost effective that can provide the same Latency, I/O and Bandwidth compared with any other All FLASH storage which is 3 times expensive than this. From a feature comparison standpoint of view, there isn't much difference between Hybrid Vs ALL Flash. HPE Nimble Storage uses ALL Flash disk at the front end to process the data thus by reducing the cost by using a regular SAS disk at the back end. Its the software and the algorithm that HPE Nimble StorageE uses to achieve this. having said that, the overall data reduction, de-duplication and compression is above the mark as what the sales team promised initially. Overall, the storage is performing well without any challenges.

Incentivized

This is an easy 10 because I actually have recommended this product to multiple clients and colleagues! Any shop that writes its own SQL queries will benefit from the insight provided by SolarWinds Database Performance Analyzer, so they know which of their queries is causing a bottleneck. Small shops or databases with only a few tables likely will see far fewer opportunities for optimization.

Incentivized

• HP Nimble is basically an all in one SAN with SSD cache or in some cases fully SSD based however the thing it does the best is its front end GUI and user management capability making it easy for anyone to ramp up on managing it quickly.
• The Nimble SAN is also very easily managed when it comes to hardware management. Outside of some major internal parts such as the mainboard, almost everything in the system is duplicated so single failures never bring the system down. Power supplies and drives are easily swapped out.
• Nimble has incredibly capable and easily accessible support that is available 24/7.
• The price point on Nimble, though higher than piecing together a home made SAN out of spare Windows Servers, is perfect even for some SMB's.

Incentivized

• Maintains historical SQL execution data, enabling forensic analysis
• Has the ability to slice and dice the data so that you can drill down to the execution of a single SQL statement being executed by a stored procedure
• Alerts to when the consumption pattern changes
• Shows historical average run times against the current, illustrating problems when they arise
• Provides tuning advice based on best practices

Incentivized

• I'd like the GUI to include more information for some of the features such as replication data totals each night. You have to go to the command line for this.
• It would be nice to have a feature built into the GUI that would show you the command line equivalent to get the same results you are seeing in the GUI.
• Although the intial setup was easy, they could always improve on that portion. During my setup, I did have to do a lot of back and forth with research on their site as to what each setting was that I was setting up. They could have provided some sort of description for each field within the setup that would have made it easier to know what they were having us set up.

Incentivized

• Alerts seem to be lacking in DPA compared to competitor's tools. They can be setup but are not quite as easy or as helpful as some other tools I have used.
• Grooming/pruning the repository database isn't very easy. We don't manage a lot of instances but our repo DB has grown pretty significantly.
• At times when I am drilled-down to a chart, it can be difficult to navigate around from that point to another time range/query/metric.

Incentivized

Nimble is doing its job well and any issues that do come up cause the Nimble support team to alert us before we would potentially see an impact to our production environment. I do wish we could expand into the unused space in the CS210 shelf which is limited by what I assume is a marketing/sales strategy, but we will likely add shelves moving forward.

Incentivized

We have relied on this product for a very long time and it continues to exceed expectations. The product is a vital part of our organization at this point, it would not be very ideal for us to abandon it. We use it almost every day and depend on its alerts for critical parts of our business

Incentivized

Almost perfect, some hoops to jump through after major upgrade, but overall simple and effective. Our storage administrator really likes the integration with vmware as it makes his life easier. Also it was no trouble integrating it with our active directory credentials. The only issue we had was getting the plugin in VMWare going initially.

Incentivized

I don't want to think about managing clusters of SQL servers in the future without this tool. We have demoed other tools and SolarWinds Database Performance Analyzer is the gold standard for usability and insight into what your servers are doing. The UI is a bit dated, but everything is laid out in a logical manner and drilling down into queries or timeslices is extremely intuitive.

Incentivized

Any time I have had to contact support, they have always been quick to respond, and very efficient in resolving any issues. When an action has been required on our side for a fix, they have been very helpful in explaining step by step what was required, and when replacement parts have been needed, we've had them within 24 hours.

Incentivized

I have had to use their support on a few occasions, for reasons that I am not clear about until recently I have always had problems upgrading the software (although the last 2 updates have gone without issue which I am very pleased to say). On those unfortunate occasions, the support has been brilliant with either excellently documented guides on how to resolve the issue by myself or have been hands-on with calls and screen sharing to remotely fix the issue. Every time the problem was sorted and more importantly, nothing was lost (apart from a bit of time). And as I stated above whatever the problem was that was causing my upgrade issues appears to have been resolved in the last 2 updates.

Incentivized

Follow the guidelines for the capacity of the servers. We found that the DPA databases were getting rather large and also that there are ways to reduce their size built into some of the options.

Incentivized

We used a Dell EqualLogic PS Series storage array for many years and it worked well. A big issue was that upgrading firmware required system downtime and during one upgrade I was unable to bring the systems back up afterwards. I spent several days on the phone over a holiday weekend with Dell and VMware support in order to get my systems back up and running. It made me very nervous about doing firmware upgrades after that.

Incentivized

At the time, we found SolarWinds Database Performance Analyzer to be easier to setup and to have a richer feature set than Redgate SQL Monitor, plus, from what I remember, the DPA pricing worked better for us over the course of a year. We're very happy with all the features DPA has to offer.

Incentivized

• 100% uptime 4 years and counting in a 24/7 environment.
• Long hardware support lifecycle, with extremely affordable maintenance renewal plans that provide real value.
• Nimble has been the most cost-effective SAN solution I have ever deployed.
• The inital costs, ongoing maintenance, and administration requirements were all 50% less than EMC and NetApp.

Incentivized

• It has allowed us to progress as an organization with much less reliance on a direct DBA than would traditionally be required
• Allowed us to be much more proactive in our performance monitoring and responding to issues that would affect users.

Incentivized