The downside of SAP IQ, from what I understood from the management side, is that the front end for the DBA, for the admin, is not that user-friendly. If you compare it with SQL Server Management Studio, it is not that user-friendly GUI for the admin. But the engine is very strong and powerful. It is easy to deploy SAP IQ; the implementation and installation are easy. The downside I see is that it doesn't allow most integrated backups; many of the marketplace players such as NetBackup, those software integrated backups are not available. So, if you want to take a backup, you need to take it locally, and then only you can back it up to any storage or anything. Those features such as integrated backup, which would allow it to stripe into an appliance or something similar, are not present. One thing I notice as a downside is that if the CPU utilization is very high, there is no direct way we can find out which query is taking the most CPU. In any other RDBMS, there are DMVs available to find out which query is taking most of the CPU, but those features are not present in SAP IQ. If our CPU is hitting at 100%, it is not easy to identify which connection is taking the most CPU.

