Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

HOW TO USE SE30?

Former Member
0 Kudos
1,993

HI THERE?

1.what are the best measures for ABAP, DB and r3?

2.if we get db>abap what to do??

3.if i get abap 55,db 45, r3: 5% what to do?

1 ACCEPTED SOLUTION

Former Member
0 Kudos
268

In Se30 , obviously we get different execution times for different runs. This is bcoz the system resource utilization , Database load vary from time to time.

Here ABAP/ Database/ System time means the utilization made by the respective ones at that particular time.

Database should be less than 25 % , Systemshould be in the medium Range and Abap should be more for better performance.

Hope this resolves your query.

Reward all the helpful answers.

Regards

Kishore.

5 REPLIES 5

Former Member
0 Kudos
269

In Se30 , obviously we get different execution times for different runs. This is bcoz the system resource utilization , Database load vary from time to time.

Here ABAP/ Database/ System time means the utilization made by the respective ones at that particular time.

Database should be less than 25 % , Systemshould be in the medium Range and Abap should be more for better performance.

Hope this resolves your query.

Reward all the helpful answers.

Regards

Kishore.

Former Member
0 Kudos
268

SE30 - Runtime Analysis Tool

This runtime analysis tools allows the ABAP/4 programmer to trace the tables used by the SAP dialog/reports programs. In the Analyze button, you can see four more buttons like:-

Hit List

Displays the execution time of each statement in the program.

Tables

Displays the tables accessed during run time.

Group hit list

Displays the execution time of all the statements and grouping them based on the type of command. e.g. performs, SQL and internal tables used.

Hirarchy

Displays the execution time of each statement in the actual order in which were executed. Uses indentation to indicate the level of nesting of statements within subroutines.

Any tables use by the transaction or program can be easily trace with the runtime analysis tools.

Go to transaction SE30

Type in the transaction code you want to analyze

4.6x

In the Restriction section: select the TMP -> Temporary variant

Click the Change button

Click the Duratn/type

Select None for Aggregation

Save the variant and execute again

After finishing the process, click back to SE30

Use F3 to move back to the initial screen of SE30

Click the Analyze Button

Click Goto -> Object-centered hit list -> Database tables

3.0x

Click Execute

After finishing the process, click back to SE30

Click the Analyze Button

Click the Table Button

After retrieving the table names, you can check the raw data with transaction SE16 - Data Browser or SE11 - Dictionary.

For example, if you want to display the data for MSEG - Material Document table

Transaction SE16

Type in MSEG for Table name and click execute.

Data Browser will display the default selection for you to display data. If you did not change the default and click execute the data browser will display the first 500 records.

Click Settings to change the List formats, User parameters and Fields for selection.

In 4.6x, you can use SE16N.

Transaction SE11 or SE12 (4.6x)

Type in MSEG for Object name and click the Display button.

Click Utilities -> Table contents for the default selection screen. If you did not change the default and click execute, the Dictionary will display the first 500 record.

Click Settings to change the List formats, User parameters and Fields for selection.

Transaction SE17

Type in the Table Name, put in the Selection value, put a 'X' in the Output column to display the data field and put in the Sort number from 01..99 (if you want to sort).

Former Member
0 Kudos
268

HI ,

1. There is no such best measures for DB , ABAP or R/3 for ex if ur code has only select query for validation and nothing else then ur DB wll show the max measurement .

2. IF we get DB more then abap(after considering point 1) then we useually go for performance optimization by avoiding select ... endselect , select*.... and nested select etc...

3. Then (after considering point 1) try to find that if there is nested loop in the progam , free internal table not in use ... , this will improve the performance..

PS: Reward Points

Regards

Naveen Gupta

Former Member
0 Kudos
268

thx

0 Kudos
268

Welcome

Please give reward points ..

Regards

Naveen Gupta