IDERA Unveils Workload Analysis for SAP HANA

IDERA, a provider of database lifecycle management solutions, has released Workload Analysis for SAP HANA, which is aimed at enabling a smooth transition to in-memory computing platform as an alternative to traditional, relational databases.

The solution helps data teams move to SAP HANA and simplifies the operation of high-performance databases, allowing businesses to benefit from the real-time insight and analytics made possible by SAP’s unique technology.

HANA is SAP’s in-memory computing platform that allows companies to analyze large volumes of data quickly to deliver more business intelligence and simplify IT operations. According to the vendor, the platform is gaining momentum in SAP environments and over other traditional database platforms where database administrators are consolidating multiple database instances to expand access to real-time data and reduce costs.

IDERA’s Workload Analysis for SAP HANA complements SAP’s native tools, providing DBAs visibility into how memory is being used and how SQL code is working in their SAP HANA instance without any of the vulnerabilities that come from full management access. With IDERA tools, DBAs can now view their entire Oracle, SQL Server and SAP database environments, including SAP HANA and Sybase ASE.

As businesses increasingly depend on the insights enabled by real-time analytics, there will be more enterprises moving highly transactional workloads from traditional databases to in-memory databases like SAP HANA, according to Ted Lester, product manager, IT management solutions, IDERA. Workload Analysis for SAP HANA can help customers make that transition, and then, as hybrid environments mature, IDERA tools can be employed to provide an end-to-end view of the database lifecycle ecosystem and connect that to the entire business stack.

IDERA’s Workload Analysis for SAP HANA provides a customizable web-based dashboard with an overview of statistical analysis and activity trends of all SAP HANA instances; and real-time performance monitoring focusing on granular, real-time monitoring and analysis of database performance to help DBAs identify problematic SQL statements, statistics for performance and heavily used components.

In addition, comprehensive performance analysis offers details for the top monitored instances, hosts, services, users and SQL statements for a selected time interval, with the ability to view trends for waits, response times, CPU and memory use and memory distribution. In sortable tables, the analysis lists top users and memory consumers. And finally, performance tuning capabilities enable optimization of HANA databases and applications to reduce costs and improve performance so DBAs can quickly deal with performance and availability problems via an automated and targeted analysis.

For more information on IDERA Workload Analysis for SAP HANA,