SAP HANA Datasphere Performance Considerations

Based on real work experience we will cover remediation of know performance issues in SAP Datasphere environments; from both native SAP Datasphere issues like, expensive queries, and inefficient CU assignments, to external factors like strained Data Provisioning Agents, remote connection abuse, or remote source restrictions. We will be covering investigation methods like: Using the integrated SAP Datasphere HANA Cockpit and Database Browser, identify Data Provisioning Agent related symptoms as well as identifying remote connection bottlenecks. Finally we will discuss tried and tested optimizing methods to maximise load distribution while minimizing strain on external tools and components.

After participating in this live session, you will be able to identifying performance causes like: Expensive queries, native capacity unit distribution, external bottlenecks, as well as identifying DPAgent memory issues and bugs. After that you will become familiar with tried and tested solutions and best practice by; optimising Quarries within the no-code development environment, optimising capacity unit distribution in relation to space management, understanding the correct use of connection types based on business requirements, remote SAP HANA DB tweaking and risks as well as understanding the DPAgent limits, config and load distribution.