From time to time You check the size of the tables in HANA using e.g. a script: SQL:”HANA_Tables_LargestTables” from SAP note 1969700 SQL Statement Collection for SAP HANA. In the column LOB_DISK_GB, You observe a large amount of space is taken up by LOB data:Continue reading “SAP HANA – reclaim LOB space”
In last time I had problem with my HANA backup. The size of backup everyday increased although in the database not appeard new data. Generally normal backup size oscillates around 1.4TB but in last day I saw:Continue reading “SAP HANA – backup size increased”
After logging to SAP HANA Studio You find information in Alerts and Mesagges: “Statistics server has been disabled. Data might be out of date“.Continue reading “SAP HANA – Statistics server has been disabled”
The load on an SAP HANA system can be managed by selectively applying limitations and priorities to how resources (such as the CPU, the number of active threads and memory) are used. Settings can be applied globally or at the level of individual user sessions by using workload classes.
In this article I try shortly show You how to use workload classes and workload class mappings. Let’s start.Continue reading “SAP HANA – Managing Workload with Workload Classes”
Using the HANA system, You can find information similar to the following in the logs:Continue reading “SAP Hana – Out of Memory information in logs”
In this article, I’ll briefly describe the steps You need to follow to enable SSL / HTTPS in SAP HANA Cockpit.
2832060 – Verification error when setting Domain Certificate for SAP HANA Cockpit
2666262 – XSA set-certificate fails
2243019 – Providing SSL certificates for domains defined in SAP HANA extended application services, advanced mode