It really depends on the purpose of usage. Both have strengths and limitations. SAP HANA is expensive especially when you try to integrate data from other sources than SAP systems. SQL Server (I believed you refer to MSSQL), is good for you to store application data. However, if you need big data analysis or advanced analytics, SQL Server may not be the best solution. The same goes for SAP HANA.
SQL Server and SAP HANA compete in the enterprise database management systems category. SAP HANA seems to have the upper hand due to its performance-enhancing in-memory processing and real-time analytics advantages.Features: SQL Server stands out with dynamic resource allocation, a complete suite of services including Analysis Services, and a robust Graphical Query Analyzer. It is praised for its OLAP capabilities, cross-platform data management, and extensive support resources. SAP HANA...
It really depends on the purpose of usage. Both have strengths and limitations. SAP HANA is expensive especially when you try to integrate data from other sources than SAP systems. SQL Server (I believed you refer to MSSQL), is good for you to store application data. However, if you need big data analysis or advanced analytics, SQL Server may not be the best solution. The same goes for SAP HANA.