Dell's PowerEdge R is a line of rack servers, offering a range of options from cost-efficient one-socket servers to four-socket servers designed to support intensive and critical data center workloads.
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.
An excellent warranty and excellent technical assistance can be expected from the PowerEdge C Series, which comes from a well-known brand with a long track record in the market. Scalability, physical space optimization and performance and dependability for handling sensitive and vital data like databases and ERP systems that are fairly sophisticated are just some of the benefits we get from Dell gear, which saves us resources and energy by up to 40%.
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
Good price - Compared to other vendors’ server platforms. In our scenario (virtualization) we found out PowerEdge offers the best price/vCPU and RAM ratio.
Customizable - We were able to select optimal memory/disk capacity for our use case. Other platform's minimum requirements were above our needs, hence needlessly expensive.
Good warranty and service - Our project did not involve creating a big cluster with a lot of spare capacity, so the next business day warranty came handy.
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
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
The Dell PowerEdge R range is just intuitive when you have skills engineers managing them in-house, although even with new members of staff on the team, the learning curve is very low providing they have previous general service hardware management experience. From the specification through to the management of this range, the usability is excellent.
We consider Dell's support to be best-in-class compared to other solutions and is also reasonably priced. Their SLA targets have almost always been met, except for minor occasions that have had extenuating circumstances. The service staff is also professional and thorough. Overall, we are very satisfied with the level of support we receive.
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
Against hp servers, Dell has outperformed them in terms of incidents regarding hardware memory parts. With the Dell PowerEdge R series servers we have not had any incidents regarding memory modules. On the other hand, with HP servers, we encountered a lot of failures regarding memory modules during the first year of implementation.
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
From the perspective of physical server consolidations, when servers spread across multiple branch and remote offices are gathered into a central data center, this simplification process provides ROI in several ways. One, the configuration control, restriction of server access.
Reduce complexity and enable greater standardization of hardware purchases, which lowers costs.
Increased security of the move are important.
The costs of moves, add-ins, and changes are reduced, as well as the costs of travel time and maintenance.
Migrating legacy operating systems to a newer version via rehosting brings similar ROI benefits when it comes to server consolidation.
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
