IT-Conductor Blog

Monitoring HANA Availability & Performance with Synthetic Transactions

Posted by Linh Nguyen on Apr 7, 2015 4:44:00 AM

The best way to check the availability and performance of any application or database is to actually login and run something, in this case a transaction. For HANA, the simplest way is to execute a SQL against the database. Automating this would serve both purposes of ensuring the database is accessible as well as being able to provide response time for particular transactions, on a periodic basis. Furthermore, it can be used to automate regular jobs such as health checks or housekeeping, without creating intricate database jobs.

To do this using SAP tools, you would need to install the HANA database client, script the transaction, and schedule it using cron or something similar. Other ways can include a more intricate robots recording and deployment by SAP Solution Manager.

With the release of the OZSoft HANA Management Pack for SCOM version 1.0.6, automating HANA Synthetic Transactions can be done in 5 minutes to schedule and monitor the status and performance of any HANA SQL or Stored Procedure against a managed HANA instance, from outside the database node(s).

Have you used Synthetic Transactions to monitor your environment?

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: SAP HANA Monitoring, Automate, HANA Availability & Performance Monitoring, HANA Management Pack for SCOM, Synthetic Transaction Monitoring, Monitor

FREE IT-Conductor Trial to Monitor SAP

Posts by Topic

see all

Recent Posts

Subscribe to Email Updates