Experience on DayLight Saving and time zone update, no need to restart SAP HANA system if it's running on different time zone except UTC and GMT.
Read MoreSAP MAX DB 7.9 Volume Administration
1. "Unlock the Secrets of SAP MAX DB Volume Management - Say Goodbye to Data Chaos!" 2. "Critical SAP MAX DB Restore Error Resolved - A Must-Read for Database Administrators!" 3. "Master SAP MAX DB Volume Admin: Expert Tips to Optimize Your Database Performance!" 4. "Don't Miss Out: SAP MAX…
Read MoreSAP HANA Revision Upgrades Made Easy: Tips for Primary, HA, and DR Success
Here’s a guide on how to make SAP HANA revision upgrades easy and successful for primary, high availability (HA), and disaster recovery (DR) scenarios: Thorough Planning: Before you start the upgrade process, create a detailed plan that includes a timeline, resource allocation, and a checklist of tasks. Identify the specific…
Read MoreSAP HANA on RHEL 8.6 Pacemaker Split Brain Troubleshooting
Due to Azure internal issue, SAP HANA DB Primary VM shut down abnormally and HANA DB takeover the Secondary VM via RHEL Pacemaker as Primary DB and SAP Applications are available, no outage occurs. Post restart of Primary VM from Azure Portal, we have identified that Primary VM pacemaker is…
Read MoreSCC4 Monitoring via Solution Manager Configuration Validation
Configuration Validation in SAP Solution Manager is a powerful tool which can help you to know the technical configuration of your SAP systems and also utilize to manage your landscape consistency according to organization requirement and also perform SCC4 Monitoring. I have recently published a SAP blog to perform the…
Read MoreSAP HANA DB Trace Files for Troubleshooting
In SAP HANA, there are several important DB trace files that can be used for debugging and troubleshooting performance issues. Some of the most important trace files are: Indexserver trace file: This trace file contains information about the indexserver process, including queries, table operations, and errors. The indexserver trace file…
Read MoreSAP HANA High Pool Usage JDBC Client
Hello All, We have observed issue in SAP HANA 2.0 SPS05 with our SAP PO(Java System) where long running sessions or called long running cursors are not getting disconnected even sessions are completed at application level. SAP HANA DB is throwing alert ID 42 “Alert Long Running/idling cursors. it’s getting…
Read MoreSAP HANA Alert 106, Impact on HANA DB and Resolution
1. Introduction to SAP HANA Alert 106 As an integral part of SAP HANA’s advanced monitoring and alert system, Alert 106 plays a crucial role in ensuring the stability and performance of HANA database environments. This article aims to provide a comprehensive understanding of SAP HANA Alert 106 and its…
Read More