SAP HANA Authorization Tracing

This document will deal with issues regarding analytical privileges with SAP HANA.

So what are Privileges some might ask?

System Privilege:

System privileges control general system activities. They are mainly used for administrative purposes, such as creating schemas, creating and changing users and roles, performing data backups, managing licenses, and so on.

How to Trouble Shoot Statistic server migration Failed

Run the following SQL to determine the time it failed at

select
        value
from

_SYS_STATISTICS.STATISTICS_PROPERTIES
where key = 'internal.installation.state'

This will return the time that the switch failed at

Troubleshooting SAP HANA Delivery Units and HANA Live Packages issues. (HALM)

Whilst importing delivery units into your HANA System you can sometimes run into some common errors which can easily be fixed without the means of opening a SAP Incident.

Lets look at an example.

Here you are importing SAP HANA Analytics into your system. During the import you see an error:

Troubleshooting SAP HANA High CPU Utilisation

High CPU Utilisation

Whilst using HANA i.e. running reports, executing queries, etc. you can see an alert in HANA Studio that the system has consumed CPU resources and the system has reached full utilisation or hangs.

Before performing any traces, please check to see if you have Transparent HugePages enabled on your system. THP should be disabled across your landscape until SAP has recommended activating them once again. Please see the relevant notes in relation to TransparentHugesPages:

HUGEPAGES 

SAP Note 1944799 - SAP HANA Guidelines for SLES Operating System Installation
SAP Note 1824819 - SAP HANA DB: Recommended OS settings for SLES 11 / SLES for SAP Applications 11 SP2
SAP Note 2131662 - Transparent Huge Pages (THP) on SAP HANA Servers
SAP Note 1954788 - SAP HANA DB: Recommended OS settings for SLES 11 / SLES for SAP Applications 11 SP3

Troubleshooting Hanging Situations in HANA

Purpose
The purpose of this document is to instruct SAP customers on how to analyse hanging situations in their HANA system.

Overview
Analyzing hanging situations.

So what constituencies a hanging situation in HANA? When we talk about a hanging situation we generally refer to a whole system wide hang, as opposed to highlighting one specific activity, ie: queries or operations. This means we are going to look at the systems conditions (performance) which leads the DB to run slowly, or not at all in some cases.

Like all other software systems, SAP HANA relies on hardware to run its processes. Even when looking at the most basic single sever, single host, we can see many areas which over lap and interact with one another, in other words, when you see a hang do not just assume the cause is all related to HANA.