SAP Support

  • SAP support
  • Dump files for support

SQL

  • SQL guide line
  • SQL references
  • Using SQL
  • Using Tables
  • Using Procedure
  • Queries and Updates
  • Using variables
  • Anonymous blocks

SQL Hands on

  • Get sql scripting skills

Tables

  • Using tables efficiently?
  • Different ways to create a table
  • Row & Column table differences
  • Row & Column tables storage
  • Create Column Table syntax
  • Create table examples
  • Ways to insert data into tables
  • Ways to select data from tables

SAP Hana Jobs

  • Finding a job in sap hana

Sap Hana training courses

  • Online training courses

Tips & Tricks

  • About tables.
  • Unexpected table type

Administration tasks

  • Daily Tasks
  • Start/Stop database
  • Start/Stop Hana System
  • hdbrsutil process tips and tricks
  • Stop or cancel SQL queries
  • Refresh data from another tenant database

Administrator User

  • Overall user administration
  • Unlock SYSTEM User
  • Unlock User
  • Activate, Unlock a user
  • Reset System user lost password
  • Create administrator User
  • Create multiple users in one go
  • Copy a user
  • Check user active or not
  • Check user status
  • Check password expiration date
  • Reset User connection attempt
  • Update password expiration date
  • Update login until date
  • Change password on first login
  • Change password on next login
  • Show Password expiration date
  • Update Password expiration date
  • Connection & password security
  • Disable password validity period
  • New user password
  • Keep old password
  • Retrieve User details
  • Create any user type
  • Drop User
  • Update User
  • De-activate/Activate User
  • Troubleshoot User

Standard Users

  • Create User with SQL script
  • Create User via Hana Studio

Technical users

  • General Tips
  • Backup User
  • Modeler User
  • Data provisioning User
  • Cockpit User
  • A user to unlock users

Configuration

  • Configuration
  • Kill long queries automatically

Log & Trace Files

  • Log and trace directories
  • Investigate backup log content

About Memory

  • Memory analysis
  • Peak Used memory
  • Peak Memory between 2 dates
  • Physical memory
  • Memory Investigation Scenarios
  • Allocated memory
  • Used memory
  • Used memory - Tables
  • Used memory - System Tables
  • Used memory - Column tables
  • Used memory - Delta storage
  • Used memory - Row tables
  • Used memory - Services
  • Used memory SQL
  • Used memory - code & stack
  • Table storage comparison

Memory Operations

  • Adding physical memory

Disk

  • Reclaimable space
  • Reclaim space

Security

  • Security Guide Line
  • Before updating a password

Privileges

  • Roles and privileges
  • Grand read access on a schema
  • Privileges to unlock user
  • Grant privileges

Backup & Recovery

  • Overview
  • Configuration
  • Backup
  • Restore/Recover
  • Checking
  • Log backup directories
  • Get backup catalog size
  • Restore database manually
  • Analyse backup log file

Troubleshooting

  • Overview
  • Common issues
  • Bugs
  • Errors
  • Performance
  • Memory
  • Alerts
  • Scripts and Procedures
  • Volume Disk full
  • Long queries
  • Alert 10: passwd authentication
  • Alert 65 log backup running too long
  • Alert 413: cannot reuse password
  • Alert 414: password to be changed
  • Alert 431: password expiration
  • 503 Service not available
  • System User lost password
  • Backint backup failure
  • Hana System cannot start
  • Locked transactions

Analyses

  • Bugs
  • Errors
  • Performance
  • Memory
  • Alerts
  • Scripts and Procedures

Investigations

  • Get Sap hana version details?
  • Get to Log and Trace directories
  • Get log backup directories
  • Get Sap Hana default Port
  • Get Session Details
  • Get Open Session list
  • Get hana user status
  • Get dump files diagnosis

Hdbsql

  • Using hdbsql?
  • Executing SQL
  • Formating output

Hana Cockpit

  • Overview
  • General Configurations?
  • URL to access Tenant
  • URL to access SystemDB
  • Troubleshooting
  • Administration
  • Monitoring
  • Open & Access Cockpit

Hana Studio

  • Installation
  • Guideline
  • SQL Console

Hdbuserstore

  • Using hdbuserstore

SapControl

  • Using sapcontrol

Free Hands on

  • Free sap hana version

Hardwares

  • Hardware for sap hana
  • Possible Architectures

Smart Data Integration

  • Configure Smart Data Integration
  • Create Data Provisioning Project Users

FAQ

  • Frequently Asked Questions

upv6r1-201911

menu.
Best sap hana training
Digg Email Facebook Google Pinterest StumbleUpon Tumblr Twitter VK linkedin
Learning SQL
SAP NOTES ABOUT "CODE & STACK"

SAP NOTES ABOUT "CODE & STACK"

×

Sap hana code and stack used memory detail analysis

Memory is straight away allocated to sap hana whenever a sap hana system starts. The linux operating system reserves memory for various sap hana processes. Program code and program stack processes are given more or less 6 GB of memory space. That space occupation is very little comparing to other elements such as table data and computational processes.

Sap hana code and stack used memory

Sap hana code and stack used memory size

Code and program stack memory size is normaly around 6 GB. The following query shows code and stack individual element size as well as the total size of those 2 elements.



--  Summary result on code and stack used memory for a tenant database.
--  Queries executed on connected tenant database.

select  service_name, 
        CODE_SIZE/(1024*1024*1024) as CODE_SIZE_GB, 
        STACK_SIZE/(1024*1024*1024) as STACK_SIZE_GB,
        round( ((STACK_SIZE + CODE_SIZE)  / 1024 / 1024 / 1024),3 )  as CODE_AND_STACK_SIZE_GB
from M_SERVICE_MEMORY
where service_name = 'indexserver'		

 SERVICE_NAME  CODE_SIZE_GB  STACK_SIZE_GB   CODE_AND_STACK_SIZE_GB 
 ------------  ------------  -------------   ---------------------- 
  indexserver          1,97           1,03                     2,07 

 
 
--  Database Name included to the result for "code and stack used memory".

DO BEGIN 

DECLARE V_DBNAME varchar(20);

select database_name into V_DBNAME from "SYS"."M_DATABASES";

select  service_name, 
        V_DBNAME as DB_NAME,
        CODE_SIZE/(1024*1024*1024) as CODE_SIZE_GB, 
        STACK_SIZE/(1024*1024*1024) as STACK_SIZE_GB,
        round( ((STACK_SIZE + CODE_SIZE)  / 1024 / 1024 / 1024),3 )  as CODE_AND_STACK_SIZE_GB
from M_SERVICE_MEMORY
where service_name = 'indexserver';	

END



  SERVICE_NAME  DB_NAME  CODE_SIZE_GB  STACK_SIZE_GB  CODE_AND_STACK_SIZE_GB 
  ------------  -------  ------------  -------------  ---------------------- 
   indexserver   TENDB1        1,9733       0,758853                   2,732 

	

Sap hana SQL management Tools

There are only few sap hana SQL tools on the market. Sap provides 2 types of SQL management tools. Sap hana Studio SQL console is a friendly client interface software which provides the most advanced SQL capability on sap hana databases. Hdbsql is a sap hana os command line sql tool which is mainly used and integrated within unix

How to use sap hana studio SQL console?

Using hana sql console

Using Sap hana hdbsql?

using hdbsql
Sap hana memory usage Sap hana memory usage
bbc world news
SAP HANA row table used memorySap hana row table used memory
SAP HANA column table used memorySap hana column table used memory
SAP HANA column table main storageSap hana column table main storage
cnn breaking news

a title

a text

a second title

a second title
a third title

Back to top

Copyright Ⓒ 2019 Best Sap Hana Training. All rights reserved
Recommended web hosting : www.siteground.com