WHY STANDARD MONITORING IS NOT SUFFICIENT FOR THE SAP DATASPEHERE AND INDIVIDUAL SOLUTIONS ARE BECOMING A MUST.
SAP Datasphere enables users to set up data models very easily. It is therefore THE go-to solution for self-service. If it weren't for the resource-intensive queries that paralyze the entire SAP Datasphere. Perhaps you have already experienced this?
To keep users happy and convince them of the power of SAP Datasphere, you should take two approaches:
One is to optimize the efficiency of system resources.
Another starting point is close and comprehensive monitoring. And since SAP's standard options in this area are limited, we offer you ISR Health Monitoring. Our system not only monitors correct rule loading, but also many other key figures to ensure a stable system.
Before we tell you more about our ISR monitoring approach, we need to clarify a few questions:
Which key figures are important?
- Expensive statements: Queries that require an above-average amount of resources.
- MDS statements by SAP Analytics Cloud (SAC) queries: Queries sent by SAC to SAP Datasphere.
- Executed tasks: Scheduled tasks within the system.
- Admission Control Events: Events in which queries are postponed or rejected due to high system utilization.
- Out of memory events: Incidents in which the system does not have enough memory available to execute a query or task.
What standard solution does SAP Datasphere offer for monitoring?
SAP Datasphere provides a basic overview of certain system metrics with the System Monitor.
The HANA Cockpit also provides key figures such as CPU and memory utilization as well as information on active threads and running queries.
How can the key figures be measured?
- CPU, memory and threads: Via the HANA Cockpit or using a DB analysis user and custom SQL code that queries data from the M_LOAD_HISTORY_HOST and HOST_LOAD_HISTORY_HOST tables.
- Expensive statements: By querying the M_EXPENSIVE_STATEMENTS table with user-defined SQL code.
- MDS statements: Restricted via SAP Datasphere System Monitoring. The M_MULTIDIMENSIONAL_STATEMENTS and M_MULTIDIMENSIONAL_STATEMENT_STATISTICS tables can be used for more detailed information.
- Task Management: Space-related via the Integration Monitor. For a more comprehensive, cross-space view, it is necessary to execute user-defined SQL queries on the TASK_LOGS table with a DB analysis user.
What challenges arise when monitoring with the standard solution?
SAP's standard tools only offer limited options. First of all, there is not one integrated standard solution, but a range of entry points with System Monitoring, Integration Monitoring and the HANA Cockpit. System admins must therefore always consider several entry points. In addition, the on-board tools only have limited functionality because, for example, it is very difficult or impossible to carry out a root cause analysis (What was the reason for high CPU utilization this morning?). Essential content (e.g. expansive statements) is simply missing. Custom SQL code is required for the analysis, most of which can only be executed as a DB analysis user. Expensive statements, for example, are not historicized, which makes tracking more difficult and requires further individual solutions.
Ultimately, a great deal of technical knowledge is required to identify and optimize resource-intensive activities. It's like a big jigsaw puzzle that has to be reassembled manually with a lot of effort every time.
Effective monitoring of SAP Datasphere often requires individual adjustments, as the standard tools do not provide all the necessary insights. However, this approach leads to increased effort and carries the risk of errors. There is therefore an urgent need for extended, automated monitoring solutions that enable holistic and efficient monitoring.
What does the ISR monitoring solution offer?
To meet these challenges, ISR has developed two solutions for customers.
ISR Health Monitoring
We have developed an integrated and automated monitoring solution for SAP Datasphere. The central element is a health monitoring cockpit, which displays the most important KPIs in an SAP Analytics Cloud dashboard and enables analyses.
ISR MONITORING COCKPIT
Summary of all important monitoring KPIs in a dashboard with the option of identifying trends and performing analyses. Reporting is based on a standardized data model that correlates all KPIs and influencing factors.
- Easy-to-use dashboard
- Integrated analysis of all relevant KPIs &
- Deep-dive analyses at statement level
Empty
IDENTIFY CAUSES
Empty
TREND ANALYSIS
Always keep an eye on the development of your environment: our solution enables you to identify long-term trends such as the increase in memory consumption over time. You decide for yourself how long the data history should be stored in your model - completely flexible and adapted to your requirements.
Empty
TASK MANAGEMENT
Get a comprehensive overview of all running tasks in the system. Quickly identify the most resource-intensive tasks in terms of memory and CPU consumption. Thanks to intuitive entry points, you can access a detailed analysis with just a few clicks - for efficient and targeted performance monitoring.
Empty
Resource guzzlers at a glance - quickly identify expensive objects
Our system automatically analyzes your environment and shows the most resource-intensive objects at a glance. This allows you to immediately identify which objects should be optimized before they lead to high memory or CPU usage. An effective tool for avoiding performance problems at an early stage.
Empty
Webinar
Efficient health monitoring for SAP Datasphere
The stability of SAP Datasphere is crucial for a high level of acceptance in the business. However, monitoring the system often involves a great deal of manual effort due to the lack of integrated and automated analysis tools. Factors such as CPU load, memory consumption and system utilization have a significant impact on performance and require targeted monitoring. In this webinar, we will show how the ISR standard solution for health monitoring enables transparent and efficient system monitoring.
ISR Health Check
- Overview of the system load
- Identification of resource-intensive processes and objects
- Proposal for optimizing the system
What are the advantages of ISR solutions?
What are the advantages of ISR solutions?
Our monitoring solution is an integrated, automated solution and offers you many advantages:
Massive reduction in complexity
Our monitoring data model contains a great deal of SQL logic (e.g. parsing JSON MDS statements, linking with CPU utilization) and standardization (e.g. standardization of CPU key figures) in order to reduce complexity for users. In this way, we contribute to a considerable abstraction of complexity for users of our data model and cockpit.
Reduction of manual effort
Complete monitoring of SAP Datasphere requires a lot of manual effort by checking various UI screens (e.g. HANA Cockpit) and executing custom SQL scripts during analyses. With the ISR monitoring solution, the manual effort is significantly reduced because, for example, the manual search for resource guzzlers is automated.
Central monitoring cockpit
There is a central cockpit for monitoring SAP Datasphere, in which the most important information is summarized. The space is authorization-relevant, so that our cockpit can also be used decentrally, e.g. by certain departments in self-service architectures. If, for example, resource-intensive objects are identified, a more in-depth analysis down to the individual SQL statement can be carried out in the Data Analyzer of SAP Analytics Cloud.
Integrated view of KPIs and influencing factors
A link is created between the central platform key figures (e.g. CPU utilization) and influencing factors (e.g. executed tasks, MDS/SAC requests and expansive statements). This enables the rapid identification of resource-intensive developments and provides information for the ongoing optimization of the data model and SAC stories.
Are you interested? Talk to us!
The monitoring of SAP Datasphere systems plays a very important role in system stability and user acceptance. SAP's standard options are limited and do not allow for comprehensive monitoring. ISR Health Monitoring is an offer to close the gap and provide customers with an integrated standard solution.
Your contact person
Carl Stegat
Professional Business Development
SAP Information Management
carl.stegat@isr.de
+49 (0) 15142205480
