Please share with the community what you think needs improvement with IBM Netezza Performance Server.
What are its weaknesses? What would you like to see changed in a future version?
This is an appliance-based product with limited capability. It has all the horse-power that one can imagine and can handle all workloads.
They should make it work better in a multi-user context. This solution works, but not for the workload we have.
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.
It really serves its purpose. It meets the need for performance, it meets the need for robustness, and it also serves as a perfect data warehousing appliance. The only issue is that it's not expandable. The new versions of Netezza, they are expandable. They can be on-prem and on the cloud like dashDB from IBM. It replaces the previous Netezza versions. We are currently on Mako because TwinFin support is going in 2019. Maybe in the next couple of years, we will be replacing Netezza with Redshift.
Concurrent Queries, with this model (1000-3), we had a very big problem using front-end tools connected on it. When using a dashboard tool to use data directly from the database, I had a big problem with queries being queued and stopped running. Looking at the manual I read that Netezza has a limited number or concurrent process.