Taking ABAP to HANA

Question 1

A HANA database can be connected as a secondary database as a business accelerator using what t-code

Answer 1

DBACOCKPIT

Question 2

How is a secondary Database accessed using Open SQL?

Answer 2

With the keyword CONNECTION. The table/view being referenced must exist in the ABAP dictionary of the main DB.

Question 3

What should be done with existing native SQL statements? (EXEC SQL)

Answer 3

See if the can be replaced with open sql. If not, they will need to be replaced with sap hana native sql

Question 4

What should be done with database hints when upgrading to HANA

Answer 4

Remove them. They will be ignored anyway

Question 5

What should be done with pooled and cluster tables when upgrading to HANA

Answer 5

Adapt the code and convert the pooled or cluster tables to transparent tables

Question 6

In select statements in HANA the data will always be returned in the primary key order?

Answer 6

No no no! The order will be entirely random unless you specify an order by in the select clause or select the results into a sorted internal table. or a table with a sorted secondary key

Question 7

What tool can be used to check for potential issues before upgrading to HANA

Answer 7

SCI (code inspector) can be used to identify these things

Question 8

What global variant for SCI is provided by sap for HANA checks?

Answer 8

FUNCTIONAL_DB

Question 9

What tool can be used to continually use code inspector

Answer 9

ATC (ABAP test cockpit) can be used to schedule SCI runs

Question 10

What process can be run in the current production system to log a limited range of potential issues as they happen

Answer 10

Run time check monitor tcode (SRTCM)
Only checks for “For all entries” without an empty table check
and Select into statements without an order by

Question 11

Post upgrade if performance issues are noted what should be done before making code changes?

Answer 11

A performance analysis using SAT (replaces SE30)

And an SQL trace (ST05)

Question 12

Is there a tool in Eclipse to assist with performance analysis?

Answer 12

Yes, open perspective “ABAP Profiling” It provides;
An overview of percentage spent in ABAP and DB
A hit list of the most time consuming methods or functions
Database accesses
ABAP Trace call
A call time line view

Question 13

What is the Performance Tuning Worklist and the SQL

Answer 13

SQL Performance Worklist (SWLT) and (SQLT) can run on a Production system to give information (as a worklist). It combines the static checks of ATC with the real time checks of the SQL Monitor

Question 14

Where does the new SQL monitor store its results?

Answer 14

The data is moved by a batch job into SQLM tables

Question 15

What are the five golden performance rules of SAP development?

Answer 15

1) Keep the result sets small
2) Minimize the amount of data transferred (more important in HANA)
3) Minimize the number of database accesses (More important in HANA)
4) Minimize search overhead (Less important in HANA)
5) Keep unnecessary load away from the database (Less important in HANA)

Question 16

What additional performance rules should be considered in a HANA environment

Answer 16

Do not select rows which will be discarded by the code

Do not select columns that will not be needed as unpacking the data is expensive