IT-Conductor Blog

SAP Basis Monitoring for Database Performance Analysis

Posted by Linh Nguyen on Oct 4, 2018 10:39:54 AM

IT-Conductor DB Performance Monitoring

DB Performance Analysis

Top down service management involves App, DB, OS and other infrastructure components, performed in a correlated fashion.  Identifying performance bottlenecks promptly within the database is very critical for enterprise applications which heavily depend on OLTP or OLAP transactions. Proactive database performance monitoring will prevent incidences that can threaten the stability of your systems. It's imperative therefore to have an effective tool and automated process for monitoring the health of your systems to ensure the continuous availability and performance of mission-critical enterprise applications.

DB Performance Analysis SAP IT-Conductor
  • Optimizing database performance requires identifying bottlenecks and resolving detected issues before system performance degenerates.
  • Correlating significant metrics like the response time, database activity such as sessions, expensive statements, resource utilization are among top KPIs to discover the main issues affecting system performance.
  • Service interference can be avoided by proactively monitoring the state of your database performance and taking preemptive steps to ensure uninterrupted system operations.
  • Obtaining the root-cause of declining database performance on time involves the monitoring of events (Resource bottlenecks like exclusive locks, DB alert logs, DB network logs, etc.) that have occurred over a period of time to gain deep insight into the issues affecting system performance.
  • The database performance can be monitored in SAP using ST04 or DBACOCKPIT. The DBACOCKPIT is a graphical user interface (GUI) used to monitor memory usage, SQL request, total DB time and other aspects of the database system landscape.
  • The HANA database can also be monitored using a variety of tools such as SAP Solution Manager, SAP HANA Studio, and the Database Administration (DBA) cockpit in SAP NetWeaver.  SAP provides database mini-check scripts which are sometimes required to run adhoc report on certain performance and utilization.
  • The health condition of your database can be determined by using the cockpit to view current metrics in the system. Historical metrics are also useful in examining the performance trends of your database over different time intervals which can help in identifying the root cause of poor system performance.
  • The challenge with most SAP tools is to correlate application workload and system resource utilization with DB bottlenecks.


  • ITC cloud solution enables Administrators to quickly discover the source of performance issues top-down (trends) as well as bottom up (events) in their applications using predefined thresholds, alerts, and reports, all without software and agents.
  • Monitoring your entire system environment with ITC can help you proactively monitor your system health and quickly detect trends before they become problems.
  • ITC supports full automation of SAP mini-check reports, or any SQL, on-demand or scheduled, and can issue recovery actions based on preset monitoring thresholds, such as HANA garbage cleanup, archive log backups.
  • ITC provides useful insights into database performance across a wide-scale and heterogeneous system landscape, using a single pane of glass for all SAP supported RDBMS platforms
  • Top DB monitors include buffers, space, IO, Process, Threads, CPU, Top SQL, DB Alerts, Backups, Resource limits
  • Accelerate application performance by leveraging on the insights provided by ITC into core system challenges.
  • Obtain correlated performance status across your system environment on a single dashboard.
  • ITC Trusted Advisor team can also provide remote DBA experts to help with DB analysis and best practices combining tools, processes and people expertise

IT-Conductor Basis Monitoring of DB Performance

IT-Conductor SAP Basis - DB Monitoring


FREE IT-Conductor Trial to Monitor SAP

Linh Nguyen

Written by Linh Nguyen

Linh was born in democratic Vietnam, escaped from the communist after the war as a boat-people refugee to Malaysia, subsequently immigrated to Australia where he attended high-school and completed dual-degrees in Computer Science & Computer Engineering in just 5 years. He started SAP career in Melbourne, then came to the US in the mid-1990s as a SAP technical consultant. He built a software and consulting company in Silicon Valley in 1996 named OZSoft and has been an entrepreneur with a passion to automate IT processes. In 2014, he started IT-Conductor, Inc. as CEO and co-founder along with David Stavisski, with the goal to help IT organizations to Stop Guessing and Start Managing by automating IT operations using a cloud-based platform IT-Conductor.

Topics: Application performance management, Performance monitor, SAP Performance Service Level Management, SAP monitoring, SAP Performance

FREE IT-Conductor Trial to Monitor SAP

Posts by Topic

see all

Recent Posts

Subscribe to Email Updates