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.
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
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.
Would you like to see this full item?