IT-Conductor Blog

SAP HANA Volumes Space Monitoring

Posted by Linh Nguyen on Feb 17, 2015 12:00:00 AM

How useful is space monitoring of HANA volumes? After all isn't the data very compressed in memory and the space consumed on the volume should be negligible? It is true that HANA has great compression on most types of data, one of the reason is that columnar tables get better compression because the data in columns tend to be more repetitive. One of the benefit of running on hardware with many fast cores is its ability to perform fast and efficient on-the-fly access to compressed data.

But I digressed, as DBAs we care about how much space is available in the database containers, and if those containers have enough room in the filesystem to grow on demand. Space should never become the reason of an outage in a well maintained database environment.

In HANA, volumes are similar as tablespaces in Oracle or DB2. However, in HANA the volumes belong to the HANA services such as indexserver, statisticsserver or xsengine. There are 2 types of volumes: Data and Log. Each of them comprises of files at the OS level and generally there are many more log segment files than data files.

To see them in HANA Studio open the Administration Console --> Volumes, expand the service under the host:port (e.g. imdbhdb:30003 for indexserver) --> Data or Log, then the Files should be displayed in the view below.

HANA-Studio-Volume-Usage-ITC

Volume Usage in HANA Studio

If you notice the Used % of the Volume, it represents how full is the file/volume (used vs allocated) based on data used compared to the total file size at the OS, and not the used percentage of the filesystem. Similar to how full is the tablespace in Oracle. The Used % of the filesystem would be the percentage Used and Total Disk size of what HANA calls the Storage Device (aka filesystem). You can see this at the Service/Volume view. When we monitor, only the Data volume file % should be considered as the Log segment files are always 100%, as they rotate members to being actively written (denoted by HANA as 'Writing')

HANA-Studio-LogVolumes-HDB

HANA Log Volumes

In scale-out deployment of HANA, where several clustered nodes with global filesystems on shared storage, the filesystems and volumes associated with each HANA service would be relocated during certain Failover scenarios. Therefore, traditional OS monitoring of the filesystem may not work well when these filesystems relocate. It is better to monitor the volumes availability and the filesystem utilization wherever the service may reside.

The diagram below shows the relationship between the OS, HANA Studio and 3rd-party monitoring by the OZSOFT HANA Management Pack for Microsoft System Center Operations Manager (SCOM)

HANAVolumeMonitoring
HANA Volume Space Monitoring

With these next generation database and advanced auto space management, it is optional for each customer to alert on volume utilization, however it is still of importance to collect metrics for growth and capacity usage. Often new environments are more closely monitored and alerted and as usage patterns are well baselined, the alerting should be toned back or thresholds raised to catch exceptional situations.

Want to monitor your HANA volumes and space availability WITHOUT installation? FREE IT-Conductor Trial to Monitor SAP

Linh Nguyen

Written by Linh Nguyen

Linh was born in democratic Vietnam, escaped from the communist after the war as a boat-people refugee to Malaysia, subsequently immigrated to Australia where he attended high-school and completed dual-degrees in Computer Science & Computer Engineering in just 5 years. He started SAP career in Melbourne, then came to the US in the mid-1990s as a SAP technical consultant. He built a software and consulting company in Silicon Valley in 1996 named OZSoft and has been an entrepreneur with a passion to automate IT processes. In 2014, he started IT-Conductor, Inc. as CEO and co-founder along with David Stavisski, with the goal to help IT organizations to Stop Guessing and Start Managing by automating IT operations using a cloud-based platform IT-Conductor.

Topics: SAP HANA Monitoring, Monitor

FREE IT-Conductor Trial to Monitor SAP

Posts by Topic

see all

Recent Posts

Subscribe to Email Updates