IT-Conductor Blog

Is Your SAP HANA Highly Available?

Posted by Linh Nguyen on Jan 13, 2015 8:37:00 AM

Pull out your SAP HANA Technical Operations Manual for the latest SPS09 release and you will find section 2.4 about Monitoring the SAP HANA Database, and section 2.9 discussing High Availability for SAP HANA at very shallow depth. After reading them, are you confident that your HANA setup is well monitored and highly available enough to go Production? If the answer is NO, then you've got some work to do before that in-memory investment can go live.

Let's start with Monitoring. Here are your choices from SAP:

  1. SAP HANA Studio
  2. SAP HANA Cockpit from a Web browser (essentially SAP DBA Cockpit)
  3. SAP Management Console
  4. SAP Solution Manager technical monitoring
  5. SAP Landscape and Virtualization Manager (LVM)

Basic monitoring should provide information on your landscape (hosts, services, detail/coordinator type, status), performance utilization, and alerts. I have set up and played with all the above and some work right out of the box but is not really an enterprise solution, like the HANA Studio or the Management Console. On the other hand Solution Manager and LVM can be time consuming to setup and maintain (see my other article Thoughts on SAP LVM) . Most IT operations teams are not going to use Solution Manager for enterprise-wide monitoring, it's just too much to manage!

 

SAPHANAStudio-Monitor-Landscape-1
SAP HANA Studio Administration Console - Landscape Monitor

If you can get the above combinations to play together for your organization, you have a head start. Otherwise, look for a third-party solution and worry about running your HANA environment instead of the monitoring solution.

Once you have monitoring taken care of, how do you test your HANA scenario, whether it's scale-out or scale up deployment, for operational robustness during failure. Sure you have the best hardware redundancy and operating system setup, but that doesn't mean HANA services or servers won't fail. This is a brief set of HA scenarios you need to test, and document expected versus actual results. Correct them if it does not meet your service level or operational objectives.

  1. Shut off a single instance of a system (whether you have one or multiple HANA instance on a cluster)
  2. Shut off one node of a system (if you have multiple nodes in a scale-out cluster)
  3. Restart one of the physical server of a system
  4. Failover a HANA Master node
  5. Failover a HANA Slave node
  6. Kill the STATISTICS service on a system
  7. Kill the INDEXSERVER service on a system
  8. Kill the NAMESERVER service on a system
  9. Kill the DAEMON service on a system
  10. Fill up the memory on one node by creating a rogue memory hog
  11. Fill up one of the HANA data volume by populating a table with dummy data

In testing these and I'm sure there are many other scenarios you can come up with as variations for your needs, you must ensure your monitoring solution detects and handles the alerts / notifications appropriately.

Please plan your operational readiness for SAP HANA adequately!

What's been your experience in effort, time, cost associated with getting SAP HANA production ready?

For HANA Availability monitoring using our best practices template try our SaaS solution 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: High Availability, SAP HANA Monitoring, Automate, HANA Failover Test, Manage, Monitor

FREE IT-Conductor Trial to Monitor SAP

Posts by Topic

see all

Recent Posts

Subscribe to Email Updates