HPE ProLiant DL is a rack server, from Hewlett-Packard Enterprise.
N/A
Vertica Analytics Database
Score10 out of 10
N/A
The Vertica Analytics Platform supplies enterprise data warehouses with big data analytics capabilities and modernization. Vertica was acquired and supported by OpenText, then sold to Rocket Software in 2026.
It's well suited for a VMWare Esxi cluster setup. You are guaranteed to have the same CPU chipset to ensure the servers on the cluster are compatible with each other. We've had to stagger the purchase of systems by six months and have had compatibility issues. It's also well suited for I/O such as MS SQL or Oracle databases, Exchange servers, domain controllers. Pretty much any server setup will work with no issues on the HPE Proliant DL line. It's less appropriate as a NAS server, we had purchased one that ran on Windows Storage. Since it was more or less running Windows as a single controller, we had issues where it has locked up and caused an outage.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Vertica as a data warehouse to deliver analytics in-house and even to your client base on scale is not rivaled anywhere in the market. Frankly, in my experience it is not even close to equaled. Because it is such a powerful data warehouse, some people attempt to use it as a transactional database. It certainly is not one of those. Individual row inserts are slow and do not perform well. Deletes are a whole other story. RDBMS it is definitely not. OLAP it rocks.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
iLO Advanced - I feel like this is just a money grab. Give me the remote features, at least the remote console, with the purchase. I'd be OK with paying for the advanced license for more centralized functionality, but straight remote sessions? That should just be there.
Software entitlements and online interaction are a little wanting. This isn't the hardware per se, but enterprise products are often heavily tied to online services and tools and that could be a lot better.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Could use some work on better integrating with cloud providers and open source technologies. For AWS you will find an AMI in the marketplace and recently a connector for loading data from S3 directly was created. With last release, integration with Kafka was added that can help.
Managing large workloads (concurrent queries) is a bit challenging.
Having a way to provide an estimate on the duration for currently executing queries / etc. can be helpful. Vertica provides some counters for the query execution engine that are helpful but some may find confusing.
Unloading data over JDBC is very slow. We've had to come up with alternatives based on vsql, etc. Not a very clean, official on how to unload data.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
We have been using these servers for many years now and we have used different generations of this product line. We have never faced a catastrophic issue using these and even the smaller issues that we have faced have been dealt with by the technical support team of HP. They have been a reliable partner in our data center.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Overall, HPE support meets our requirements. They offer handy 24x7 phone support with clear case resolution interface. Engineers from HPE know their hardware and software. They are polite and help to find quick solutions for their customers. We don't need to prioritize our service requests to account managers to find how to fix or improve our service support.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I haven't had any recent opportunity to reach out to Vertica support. From what I remember, I believe whenever I reached out to them the experience was smooth.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I've used Dell poweredge servers and they were great too, but I found remotely deploying HPE hardware was significantly easier and faster. One thing I love about HPE is when i got to deploy an OS remotely via iLO I can utilize the virtual media URL as opposed to mounting an iso. these eliminates the SSL overhead and the OS can be deployed in under an hour. Mounting an ISO has proven reliable but due to the SSL overhead it can take hours. In addition i found im able to register my HPE hardware with HPE and they provide me a clean IT dashboard of all of my hardware and they give me alerts as to expiring support coverage, if a server is down or reporting an error. its a very solid and reliable solution all around.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Vertica performs well when the query has good stats and is tuned well. Options for GUI clients are ugly and outdated. IO optimized: it's a columnar store with no indexing structures to maintain like traditional databases. The indexing is achieved by storing the data sorted on disk, which itself is run transparently as a background process.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Allowed us to move forward with running web-based applications and to scale them as needed.
The lack of future driver support has made it difficult to consider upgrades, we may need to go with more expensive hardware in the future to be able to maintain upgrades.
While we have not realized all the business growth benefits we expected from this investment, we have had much more flexibility and options when we need to change our environment to meet the business needs.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
