Q. How to do performance testing in PRD system What are pre-requisites?
Ans. With SAP Netweaver 7.5 SP you can do performance trace in PRD system without much overhead, in two steps st Administor the SQLM ( tcode) – start and stop the trace. 2
nd
: Data:
SQLMD ( tcode ) in the order of the potentially expensive statement.
In order to find performance trace priority list : use tcode : SWLT ( SQL Performance tuning worklist )
Q. Class to calculate runtime in ABAP on HANA?
Ans: CL_ABAP_RUNTIME
Q. How to specify client field in Native Query?
Ans: Using SELECT DISTINCT / CLIENT SPECIFIED / USING CLIENT
Q. Tcode for EPM scenario?
Ans: SEPM_DG – Data Generator
Q. What are different Code-pushdown techniques?
Ans:
1. SQL Queries _ imperative and declarative logic (use literals, arithmetic, logical expression inside the queries and using expressions like CEIL, FLOOR, ABS, TRUNC, FRAC can be part of
Open SQL statements ),
2. CDS Views. AMDP : ABAP Managed Data Procedures. Information Models and consuming those in ABAP using proxy object techniques
Share with your friends: |
