Sap Support

- Sap Support - Dump files for support

Log & Trace file

- Log and trace directories - Investigate backup log content

Tools : Hana Studio

- Installation - Using hana studio - Using Studio SQL Console

Tools : hdbrsutil

- hdbrsutil tips & tricks

Tools : Hana Cockpit

- Install hana cockpit 2 complete example - Un-Install hana cockpit 2


- Disk space used by log segments - Reclaim space from log segments - Retrieve table index space used on disk

Specific Operations

- Adding physical memory

Sap Hana User Privileges

- Role and privileges - Grant read access to a schema

Stored procedures

- Creating a procedure - Dropping a procedure - Compiling a procedure - Executing a procedure - Working with procedures - Using anonymous block

Sap Hana functions

- DateTime : ADD_YEARS - DateTime : EXTRACT


- Configuring sap hana - Kill long queries automatically


- Sql guide line - How to use SQL -Sql references - Sql tips & tricks for tables

SQL Query

- SQL & Tables - SQL & syntaxes - How to practice SQL

Sap Hana Tables

- Managing tables - Various ways to create Tables - Sap Hana Tables - Sap Hana Temporary Tables

Table description & DDL

- Retrieve table description - Table description using table-columns-view - Table ddl with hana studio - Table ddl using 'get_object_definition' procedure - Table ddl using hdbsql


- Various ways to select data


- Various ways to insert data

Sap Hana Users

- Managing Users - Create user with hana studio - Create user with sql Script - Create multiple users in one go - Copy a user - Create User with SQL script - Create User via Hana Studio - Update User - Drop User

Create Standard User

- Create standard & personal User

Create Technical User

- Create a technical User - Create backup users - Create administrator users - Create Modeler User - Create Data provisioning User - Create Cockpit User - Create a user to unlock any users

How to use sap hana minicheck?

Sap hana minicheck is a script which provides an overall checkup result of a tenant database at a particular moment in time. This is a good starting point to get a good health check of a specific sap hana database. The report points out when a value is not matching what is normally expected. The result does not mean there is a problem but you have to understand what is behind the reported values in order to validate an action or not. Running the sap hana minicheck is really relevant after few months of tenant database use. Sap Hana System Database analytic data is then more mature and will provide more appropriate results in regards various performance statistics.

Using a minicheck in hana studio requires few actions. The first one is to get the minicheck file corresponding to you sap hana database version. You get it from the SAP web site. After you got the file, it has to be imported into Sap Hana studio. To retrieve the minicheck in hana studio follow the steps: 1/ "Open Administration", 2/ Goto "System Information" tab, 3/ Drill down the sap hana minicheck imported file name ( Configuration, Minicheck, and finally, double click the version you want to execute the script )

How to get and import sap hana minicheck file in hana studio?

The minicheck sql script is to be downloaded from Sap Site [ id required ] : Note 1969700 . Sap Note "1969700 - SQL statement collection for SAP HANA" html page gives further details about sql statements. Generally speaking, to import the minicheck file you have to follow those steps:
A/ Download the file,
B/ Connect to hana studio,
C/ Connect to a tenant database,
D/ Select "Open Administration",
E/ Select "System Information" tab,
F/ Right click on the "System Information" window area,
G/ Select Import SQL Statements.
That is it.

Get Minicheck file step by step

Download Minicheck file

How to execute sap hana minicheck in hana studio?

The file retrieved from the sap Note 1969700 provides all sorts of sap hana SQL scripts. When the file has been completely imported in hana studio, sap hana predefined scripts appear all over the place. They can be useful on specific analyses basic. Saying that the minicheck script you are looking for does not appear to be right there. There are various ways to look for it. Either use the filter which will show more than one result or go directly to the relevant tenant database minicheck SQL statement which is situated in : Import date , Configuration, Minichecks.

Execute Selected Minicheck Script

Minicheck Report Example

Sap hana SQL

Sap hana tools

- - -