SAP HANA Performance Monitoring Using Design Studio

  • by Dr. Bjarne Berg, Principal and Tax Data Analytics and Business Intelligence Leader in Tax Technology Compliance, PricewaterhouseCoopers, LLP
  • Michael Vavlitis, Program and Project Associate Manager, Accenture MCaaS (Mortgage and Compliance as-a-Service)
  • October 21, 2014
Learn the details around the process of developing and implementing SAP HANA performance monitoring using an application built by BusinessObjects Design Studio. Active performance monitoring is a vital measure for maintaining the stability of an SAP HANA system, and Design Studio offers the ideal capabilities to track the most important SAP HANA performance indicators.
Learning Objectives

Reading this article, you will learn how to:

  • Examine the SAP HANA key performance indicators, including their definitions and why they should be tracked
  • Learn how to implement Design Studio to build a performance monitoring application
  • Leverage the Design Studio interface to achieve the desired analytics
  • Pull data from SAP HANA into Design Studio
Key Concept

SAP HANA presents cutting-edge, in-memory, data-processing performance. However, like all database management systems, there are key performance indicators that must be tracked as part of the routine maintenance. These performance indicators are found in several areas inside SAP HANA. In this article, we look at how these indicators can be consolidated into a single dashboard monitor using SAP Design Studio.

Continuous, proactive monitoring of the status of production systems, its services, and the consumption of system resources is crucial to detecting problems early. This allows you to prevent or minimize service disruptions. SAP HANA is no different from any other system in this regard. However, the collection and evaluation of statistical data at defined periodic intervals is built into the SAP HANA database. This embedded statistics server or, more recently, the statistics service of the index server, is part of the internal monitoring infrastructure of the SAP HANA database.

The statistical data that is collected via internal monitoring is stored in tables within the _SYS_STATISTICS schema. The data is periodically evaluated to alert users of critical situations, such as when a disk is almost full, memory usage has exceeded a specific threshold, or a server has stopped working. This data is stored for a configurable time period which is usually set to 30 days by default. This information can be used to facilitate performance and stability monitoring of not only the SAP HANA database, but also the SAP HANA application.

The statistical information collected by the SAP HANA database may be monitored using a variety of tools such as SAP Solution Manager, SAP HANA Studio, and the Database Administration (DBA) cockpit in SAP NetWeaver. In addition, more generic Operation System monitoring tools such as Topaz can be used to monitor the system from an external perspective. However, all these tools have limited insight into the memory manager within SAP HANA.

Dr. Bjarne Berg

Dr. Bjarne Berg is a Principal and the Tax Data Analytics and Business Intelligence Leader in Tax Technology Compliance (TTC) at PricewaterhouseCoopers (PwC), LLP. He is responsible for analytics and go-to-market strategy. Dr. Berg is an internationally recognized expert in BI and a frequent speaker at major BI and SAP conferences world-wide, with over 20 years of experience in consulting. He regularly publishes articles in international BI journals and has written five books on business intelligence, analytics, and SAP HANA. Dr. Berg attended the Norwegian Military Academy, and served as an officer in the armed forces. He holds a BS in Finance from Appalachian State University, an MBA in Finance from East Carolina University, a Doctorate in Information Systems from the University of Sarasota, and a Ph.D. in IT from the University of North Carolina.

See more by this author

Michael Vavlitis

Michael Vavlitis is a proven business professional who has successfully completed projects and implementations in the U.S. and Canada. His practical experience ranges from business intelligence development and reporting using SAP Data Services, SAP HANA, SAP BW, and SAP BusinessObjects, as well as serving in a project team lead role.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.