How to Stop and Start SAP HANA Tenant Database

There are multiple way to stop and start SAP HANA Tenant Database . But i personally prefer to stop and start SAP HANA Tenant Database using SAP HANA Studio . Step 1- Launch SAP HANA Studio and open SQL console .     Once SQL Console is open then you can execute below mentioned sql commands for Stop and Start SAP HANA Tenant Database.   How to Stop SAP HANA Tenant Database: ( SMH is TENANT DATABASE SID): alter system stop ……

How to Generate full system dump in hana

If You are experiencing high memory consumption / out of memory situations . SAP is asking you to generate full system dump for further analysis. This blog with help you to generate Generate full system dump in hana. Goto  /usr/sap/<SID>/HDBXX/exe/python_support directory Run python script fullSystemInfoDump.py as following:   <HOSTNAME>:/usr/sap/<SID>/HDB10/exe/python_support> python fullSystemInfoDump.py -t <TENANT SID> System Info Dump created 2019-07-22 11:09:20 (UTC) with script version 2.00 Called with command line options: -t <TENANT SID> Writing to file /usr/sap/<SID>/SYS/global/sapcontrol/snapshots/fullsysteminfodump_SMH_SM1_solman_2019_07_22_11_09_20.zip —– 2019-07-22 16:39:20 Generate esserver stack ……

How to Generate a Runtime Dump on SAP HANA

If You are experiencing high memory consumption / out of memory situations . SAP is asking you to generate a runtime dump for further analysis. This blog with help you to generate a runtime dump in HANA database.   Easiest way to generate runtime dump is from OS Level:   1) Log into the HANA host as sidadm user 2) Run command ‘hdbcons’ 3) On the hdbcons console run command below > runtimedump dump This will create a runtimedump for the host ……

kernel profiler trace HANA

How to Generate Kernel Profiler trace in HANA If You are experiencing high memory consumption / out of memory situations . SAP is asking you to provide a Kernel Profiler Trace. This blog with help you to generate kernel profiler trace in HANA database. start a kernel profiler trace on OS level by running the following command as HANA sidadm >hdbcons -p <pid_of_the_problematic_tenant_indexserver> >profiler clear >profiler start {wait for 4-5min} >profiler stop >profiler print -o profiler_cpu.dot,profiler_wait.dot   This will basically create ……

SAP HANA Cloud Platform-Overview- Key Features-How to purchase -30% off deal

SAP HANA Cloud Platform: SAP HANA Cloud platform is next generation SAP where you can Build, integrate, and extend applications in the cloud quickly and easily Designed for the department, small business, or midsize company, SAP Cloud Platform, user-based packages enable your organization to develop business applications in the cloud quickly and easily.   Here As a partner of SAP we are providing great deal to buy SAP HANA Colud Platform edition and with this deal you can start with ……

HOW TO ADD SAP HANA SYSTEM IN HANA STUDIO

In this article i am going to explain how to add HANA system into HANA Studio In order to connect to a SAP HANA system we should have HANA Server detail and the Instance Number also Username & Password combination to connect to the instance. How to add new HANA system: Open HANA Studio and Right click in the Navigator space and click on Add System Enter HANA system details. Hostname & Instance Number Mode– Single Container and click on ……

SAP HANA PATCH UPGRADE

This articles covers step by step details for SAP HANA patch upgrade.Here i am proving complete steps for SAP HANA Revision upgrade from Revision 121 to Revision 121   In our case the source HANA version is SPS 12 Database Revision 121 and SPS 12 Database Revision 122. SAP HANA REVISION UPGRADE / PATCH UPGRADE Pre-Upgrade Steps: 1. Check Source Source Version: Download the media files from service market place (https://service.sap.com/swdc),Here we downloaded DVDs for HANA version is SPS 12 Database Revision 122. ……

SAP HANA DATABASE BACKUP and RECOVERY

Even though SAP HANA database is a In-Memory database as it data resides in memory But it doesn’t mean that If power goes off data will also go like physical RAM Data is always saved from memory to disk at save points and data changes are written into redo log files.So in case of failure they can be used for recovery. The SAP HANA database keeps data in memory for maximum performance, but still uses persistent storage (disk memory) to ……

SAP S/4 HANA Installaiton using up-to-date installation

SAP Installation procedures are getting changed with its new generation Tools and products. Up-To-Date Installation Process ( UDI) SAP S/4 Hana should be installed suing UDI .In the New Installation process called UDI (Up-To-Date Installation Process), we can Install and upgrade /update the SAP systems in One Step. It Comes with following benefits 1) Execution phase is simplified IE. SWPM and SUM can be clubbed together and executed. 2) Target System Calculation is simplified using Maintenance Planner 3) We can ……