We are consolidating SAP HANA into our environment as one of our primary projects. This is not a greenfield implementation, but rather a conversion from our current environment to the consolidated project, where multiple databases are combined into one. So far, this has been going well, and the major advantage of SAP HANA is that it can read both rows and columns at the same time, unlike other databases. Despite this progress, we still need to evaluate its performance as it has not been as fast as we initially anticipated.
This database for SAP is deployed on-premises, and it supports over 40 SAP applications in our environment.
I provide the infrastructure support for data centers and databases, and I can see that the background jobs run much faster with SAP HANA than with Oracle or DB2. Furthermore, SAP HANA has fewer licensing issues, making it cheaper than Oracle. Additionally, the support for SAP HANA is the best we have seen.
The best part of our multi-node system is its ability to help us a lot. This system consists of a primary and secondary node, which is a database, and it works effectively.
SAP's HANA database is said to be the fastest database, with simultaneous reading and writing of rows and columns. However, we have not seen the promised improvement in speed. Additionally, shutting down a large database of 6 TB can take up to 30 minutes, whereas databases of other types are much faster to shut down. The long recycling process of HANA can be quite frustrating and has room for improvement.
When there is blocking occurring on the database level, the process responsible for it should be killed automatically. We have not seen any CPU or memory increases, but often the memory is almost completely utilized in Linux environments where HANA is installed. As HANA cannot be installed on any other OS, the memory usage should be checked to determine why it is almost entirely taken up.
The cost of the solution is high and has room for improvement.
I have been using the solution for almost five years.
I give the stability of SAP HANA an eight out of ten.
I give the scalability of SAP HANA a six out of ten.
The return on investment is good and that is why we are moving ahead with the transition.
SAP HANA is expensive, but unfortunately, we do not have any alternatives. Therefore, we must transition to HANA databases by 2025.
I give the solution a six out of ten.
Anyone currently using SAP will be transitioning to HANA. Those who wish to implement SAP will also be using HANA, as it is the only supported platform for SAP applications, not for any other applications.