SAP IQ Room for Improvement

Noufal Hameed
Technology Lead at a tech services company with 10,001+ employees
Yes. The room for improvement would be the marketing of the product, because this product is much better than advertised. One of my colleagues was working with Adobe, where the Product Management team was using Hadoop. Hadoop was doing a performance test, let's say excessive performance, and X plus X was the performance improvement of the SAP IQ. Thus, SAP really has to really market this product very well because of its patented indexes. Because it's patented, the compression is even far better than SAP HANA. So, they have to improve it and its use, the RLV in memory solution. The RLV is there so they are currently using it just for keeping delta data. Instead, what I would recommend is, you have to take it into the next level and include it in memory data space and in memory database. View full review »
OktayElmas
Senior Database Administrator & BigData Administrator at a financial services firm with 10,001+ employees
They should improve the backup options. There is no backup software support for Sybase IQ. You have to implement your own backup system. For large databases, you need to use disk backup solutions and it is very expensive. Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups. It is very hard to find which sessions cause a performance problem. It also has no resource manager to manage resources between consumers. View full review »
SeniorSa6ed4
Senior SAP SYBASE/SQL SERVER DBA at a financial services firm with 10,001+ employees
I think the universe should be part of the Sybase IQ tool set. View full review »
Chetan Niloor
MSSQL DBA,SAP IQ DBA/ASE at NuWare Systems LLP
Concurrency and functional error messaging. View full review »
Richard Pitsnogle
Lead Technical Specialist at a financial services firm with 10,001+ employees
There could be more documentation and training. View full review »
Alex Fridland
Database Senior Manager at a financial services firm with 201-500 employees
Concurrency and functional error messaging. View full review »

Sign Up with Email