Workload Analysis for SAP HANA

SAP HANA Database Performance Monitoring

Workload Analysis for SAP HANA

  • Fast, granular, real-time monitoring and analysis for SAP HANA
  • Locate problematic SQL statements within the SAP HANA software stack
  • Prevent problems to reduce SAP HANA service failures
  • View statistics for performance after migration to SAP HANA
  • List heavily used components to optimize with SAP HANA

פרולוג'יק היא המפיצה הרישמית של מוצרי IDERA בישראל.
כמו כן פרולוג'יק מספקת חבילת מוצר מושלמת הכוללת אינטגרציה, ליווי והדרכה.

workload-analysis-for-sap-hana-10-a-monitored-instances
  • Fast, granular, real-time monitoring and analysis for SAP HANA
  • Locate problematic SQL statements within the SAP HANA software stack
  • Prevent problems to reduce SAP HANA service failures
  • View statistics for performance after migration to SAP HANA
  • List heavily used components to optimize with SAP HANA

Fast, granular and real-time database performance monitoring and analysis

Focus on database performance monitoring and analysis by continuously sampling SQL queries with high granularity.

Locate problematic SQL queries within the software stack

Locate problems within the software stack including which application instance, cluster or service. Further identify the location of the problem within applications, reducing the mean time to resolve issues.

Prevent problems to reduce the time between services failures

Detect problems early and prevent problems in the future. Consequently, reduce the mean time between failures of services.

Provide statistics for performance before and after a migration

Display statistics for performance both before and after migration to SAP HANA to reduce risk.

List heavily used components to optimize with SAP HANA

List heavily used components such as hosts, users, services, areas, and SQL statements. Also, display the likely performance gain that can be realized when optimizing with SAP HANA such heavily used components.

Database Performance Monitoring and Analysis

Continuously monitor database performance. Get a comprehensive real-time view of entire instances with continuous sampling and high granularity as fast as 1 second.

Locate Problems in Software Stack

Easily drill-down to quickly isolate problems in the SAP HANA software stack. View the details of the captured data (such as top waits, CPU and memory utilization, and SQL statements versus top hosts, users, and services) to pinpoint problems and their resolution.

Easy Timeline Display

See graphical information for a user-defined period and refresh every 15 minutes. Zoom in by dragging with the mouse over a graph to define the area to zoom in on to view detail. Graphs displaying current information show the last 30 minutes of data in maximal granularity and refresh every 1 minute.

Simple Web-based Dashboard

Workload Analysis for SAP HANA provides a single customizable web-based interface accessible via a browser from any machine that can access the framework machine. The panel displays a high-level overview of statistical analysis and activity trends of database activity and top utilizing SQL statements, hosts, users, and services. Quickly isolate slow SQL statements in a sorted, easy-to-use table.

Monitor Failover Clusters

Monitor in a failover cluster configuration by installing Workload Analysis for SAP HANA on a dedicated server outside of the cluster. During a failover, it will quickly identify the failover, and within moments, resume monitoring automatically without any manual intervention.

Agentless and Low Impact

Monitor SAP HANA instances remotely from a dedicated framework machine. Workload Analysis for SAP HANA is agentless and does not install additional services, databases, tables, extended stored procedures or anything else on the production systems. This simple architecture significantly reduces server footprint, simplifies the installation and upgrade process, and eliminates risk to the performance of the monitored SAP HANA instances.

Management Desktop Console

  • Microsoft Windows: Vista SP1+, Server 2008 SP1+, 7, Server 2008 R2, 8, Server 2012, 8.1, 10
  • Microsoft .NET Framework: 4.0+
  • Microsoft Data Access Components: 2.8
  • Monitor screen resolution: 1280×800 pixels
  • Monitor text resolution: small

Web Dashboard

  • Microsoft Windows: Vista SP1+, Server 2008 SP1+, 7, Server 2008 R2, 8, Server 2012, 8.1, 10
  • Microsoft .NET Framework: 4.0
  • Web browsers: Microsoft Internet Explorer IE 9.x+, Google Chrome, Mozilla Firefox

Services and Data Repository

  • Microsoft Windows: Vista SP1+, Server 2008 SP1+, 7, Server 2008 R2, 8, Server 2012, 8.1, 10
  • Microsoft .NET Framework: 2.0 SP2+
  • Microsoft Data Access Components: 2.8

Supported Monitored SAP HANA

  • SAP HANA: Support Package Stack (SPS) 05 – Revision 45 (November 2011) or later

Workload Analysis for SAP HANA does not install any components, DLLs, scripts, stored procedures, or tables on the monitored SAP HANA instances.