We performed a comparison between IBM Netezza Performance Server and SQL Server based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."IBM Netezza Performance Server is a cost-effective solution."
"The benefit is really because of the additional speed that we have and, truth be told, the more updated ETL processes and the revamped scheduler in general."
"We are able to execute very complex queries. Over 90 percent of our query executions are one second or less. We do millions of queries everyday."
"Distribution concurrency control."
"The data governance prospect... from what I've seen, that is a really powerful tool as well, to help with data lineage and keeping track of that."
"The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."
"The underlying hardware that IBM provides with this appliance is made for a specific purpose, to serve performance on a large amount of data, and to do analytics as well. It is faster, when you compare it to any other product."
"The performance is most important to me, and it helps our ability to make business decisions quickly."
"Having everything in one centralized set of databases is the most valuable feature."
"There is no lack of features."
"It is the latest technology and pretty powerful in terms of the high availability of the virtual server."
"I like the availability group functionality. We are setting up more clusters using availability groups. The enterprise licensing or Software Assurance makes it a little bit cheaper as well. It is nice to have that read-only copy for reporting and everything else."
"Its availability for a secured server is one of its most valuable features. Also its replications - we can manage eight replicas. Their clustering and availability groups are also valuable."
"It can go easily on a virtual machine and be accommodated by a virtual machine easily. That is a plus, as not all databases can handle that."
"Stability and usability, which is quite simple, are two of the solution's most valuable features."
"SQL Server is similar to other Microsoft products, such as BI, they are easy to use. You do not need to have an expensive BD to maintain them. All the useful intuitive features you find in Microsoft solutions you will find in SQL Server."
"The only issue is that it's not expandable."
"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."
"We are not able to scale. The only way to scale is to get another appliance, but we have a customers who would need us to hydrate the data between the two appliances, and Netezza does not do that."
"Our main problem with it is concurrency. When there are too many users running Netezza at the same time, this is when we have the most complaints."
"Concurrency limit needs to be increased somewhat."
"Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server."
"LIke Teradata, we can’t add a node/SPU to the existing appliance."
"In terms of features that I would like to see, one is the ability to actually scale out an architecture. Right now, if you buy one, it's fixed. There is no scale-up availability at all."
"Our biggest problem with SQL Server is latency. The communication between the cloud and the on-premises environment is slow. The data needs to be encrypted for security, and you have to exchange data certificates between environments. You can adjust the configuration to improve performance, but it would be nice if SQL Server had some templates to resolve problems."
"The Task Scheduler has a lot of shortcomings. This could be improved quite a bit."
"The pricing could be more affordable."
"For small-scale businesses, Microsoft could improve by removing some limits in SQL Express."
"The documentation could be much better. It's lacking right now. If there are better help pages, for even complicated queries and stuff like that that would be quite a help for users."
"The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient."
"The performance needs some improvement and it needs more features integrated into it."
"I would like Microsoft to evolve SQL Server because stateful databases dying are in a way. We would like to find out if it can absorb Hadoop and other similar things. They should make it useful for data mining. Data is evolving forever, and how we store it is also changing constantly. So, SQL Server also needs to change."
More IBM Netezza Performance Server Pricing and Cost Advice →
IBM Netezza Performance Server is ranked 10th in Data Warehouse with 33 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. IBM Netezza Performance Server is rated 8.0, while SQL Server is rated 8.4. The top reviewer of IBM Netezza Performance Server writes "A cost-effective data warehousing tool, but security features like TDE encryption are missing". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". IBM Netezza Performance Server is most compared with Oracle Exadata, Oracle Database, Snowflake, Teradata and IBM Db2 Database, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Db2 Database.
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.