Microsoft Parallel Data Warehouse and Dell PowerStore compete in the data storage and management category. Dell PowerStore appears to have the upper hand due to its stronger integration with VMware, machine learning functionalities, and robust NVMe support, setting it apart in terms of performance and scalability.
Features: Microsoft Parallel Data Warehouse enhances data loading times significantly, integrates seamlessly with the Microsoft ecosystem including Power BI, and boasts strong OLAP capabilities. Dell PowerStore provides exceptional integration with VMware, supports NVMe for high performance, and excels in deduplication and compression, enhancing storage efficiency.
Room for Improvement: Microsoft Parallel Data Warehouse could benefit from better integration with non-Microsoft tools, improved scalability, and less setup complexity. Dell PowerStore needs more stable upgrades, enhanced NAS functionalities, and better price flexibility alongside improved support and security features in relation to the S3 protocol.
Ease of Deployment and Customer Service: Microsoft Parallel Data Warehouse offers flexible deployments with options for on-premises, public, and hybrid cloud setups, while Dell PowerStore is primarily focused on on-premises with excellent VMware integration. Customer service for both is generally satisfactory but users of Microsoft Parallel Data Warehouse often rely more on online resources compared to Dell PowerStore's traditional support approach.
Pricing and ROI: Microsoft Parallel Data Warehouse is noted for its cost-effectiveness, especially for large data sizes, with an all-inclusive licensing model that avoids hidden costs. Dell PowerStore, although positioned as more expensive, offers competitive pricing given its NVMe and deduplication capabilities, and is recognized for delivering significant ROI through effective data management and integration with existing tools.
We have reduced infrastructure but the same performance.
With Dell PowerStore, even if the report runs and taxes out the database server heavily, the tool doesn't suffer from a performance hit.
It identified some areas in which we could get some good reductions and could decrease the data center footprint.
If necessary, they will search for a specialist within their Dell network who we can approach with our questions.
I would rate the technical support of Dell PowerStore between nine and ten out of ten.
The solution's technical support is excellent.
The customer likely exceeds 20,000 users globally.
While the solution can be vertically scaled without issues, horizontal scaling presents challenges.
The smaller models are not very scalable, while the larger ones offer better scalability.
I give the scalability an eight out of ten, indicating it scales well for our needs.
Stability-wise, I rate the solution a ten out of ten.
I would rate the stability of Dell PowerStore a ten out of ten.
There are no bugs or glitches and it doesn't crash or freeze.
Microsoft Parallel Data Warehouse is stable for us because it is built on SQL Server.
If you want to delve into where your I/Os are going, the reporting might need more in-depth information to make informed decisions.
In my organization, we have had to go through two weeks with no replication, which is not very handy for our production environment.
Something needs to be done with the caching to ensure that if some issue occurs, there needs to be an ability to disable caching during maintenance to make it static, safe, and good.
When there are many users or many expensive queries, it can be very slow.
Microsoft Parallel Data Warehouse is excellent but very expensive.
The ETL designing process could be optimized for better efficiency.
Likely the cost is $400,000 whereas IBM may be $250,000.
We bought a solution that was half the size of the initial solution, and we got a compression ratio of about five to one.
It's an all-inclusive license, so there are no additional charges.
Microsoft Parallel Data Warehouse is very expensive.
This digital machine can be managed entirely remotely, with an automatic download available from Dell.
The solution's most valuable features are the quick data compression process and ease of scalability for all types of support contracts.
Typically, high-performance and high-availability features, such as application snapshots and remote and local replication, are highly valued.
The columnstore index enhances data query performance by using less space and achieving faster performance than general indexing.
Microsoft Parallel Data Warehouse is used in the logistics area for optimizing SQL queries related to the loading and unloading of trucks.
The interface is very user-friendly.
Dell PowerStore stands out for its high performance, flexibility, and easy integration with VMware. It offers notable data compression and deduplication capabilities while providing powerful NVMe support and machine learning to optimize IT operations.
Dell PowerStore is designed to offer a comprehensive approach to IT infrastructure by enhancing performance and simplifying management. It is particularly suitable for companies that require scalable solutions to increase compute or capacity independently. Featuring built-in intelligence, PowerStore allows efficient storage consolidation and reduced footprint, while integration with CloudIQ enhances monitoring and analytics. However, there are areas for improvement, such as stability, enterprise features, and the user interface. Pricing is high, and support responsiveness needs attention. Organizations primarily use PowerStore for VMware environments, storage, and data protection, supporting high-performance databases and VMware workloads. It is utilized in data centers for disaster recovery and hybrid setups.
What are the key features of Dell PowerStore?In industries like IT, finance, and healthcare, Dell PowerStore supports efficient data management and enhances infrastructure performance. Organizations leverage it to manage extensive data, streamline virtualization processes, and facilitate migration from legacy systems, while integrating cloud and on-premises infrastructures for improved operations.
The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.