Run Time Analasys

[Former Member]

Hi All,

can any one explain regarding .. Run Time Analasys ans sql trace???

How we use 2 technics in a Program???

example and steps plz..

Regards,

vijay.

[Former Member]

Hi,

SQL trace provides the developer with the ability to analyze database select statements. Execute Tcode ST05

> Turn on SQL trace, then execute the program which you want to analyze. > Turn off trace. > Click on list trace to view the details.

Check the below Links:

http://help.sap.com/saphelp_erp2005/helpdata/en/d1/801f89454211d189710000e8322d00/content.htm

http://www.sapbrain.com/TOOLS/SQLTRACE/SQL_TRACE.html

http://www.sapdevelopment.co.uk/perform/perform_sqltrace.htm

ST01 SAP systems trace

ST02 Buffer statistics.

ST03 Workload analysis.

ST04 Database performance analysis.

ST05 SQL trace.

ST06 Operating system monitor

For Run Time Analyser, its worth to check the below link, our community already discussed on this,

Regards,

Suresh

Message was edited by:

SureshKumar Ramamoorthy

[Former Member]

hi vijay,

Runtime analysis will give the overall performance of your program, say the time taken by abap, database and system. according to the severity, in abap, DB or system, you can tune ur program for better performance.

ST05 will give the performance of each database hit through the SELECTs in your program. it also gives the time taken by the tables used in your program. with this you can tune the SELECT statements. you can find this from Cost to Rows ratio too.

ST05:

activate the trace >execute the program> after the execution is over, deactivate the trace -->display trace.

then go to "trace list" --> summarise by tables or summarise by sql statement.

regards,

madhu

[shishupalreddy]

Hello,

U can use STO5 Sql Trace for better performance tuning of u r porgram ..as Runtima Analysis tool will not give u the exact performance ...even u can check the same by executing the program for 2 or 3 times ....

regards

[Former Member]

1. Run Time Analyser

http://help.sap.com/saphelp_47x200/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/content.htm

2. SQL trace

http://help.sap.com/saphelp_47x200/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm

Regards,

Santosh

[Former Member]

Hi vijay,

Use

The SQL Trace function is an on-demand log of selected SQL statements that are issued against the database through the Open SQL Engine. The SQL Trace can be switched on or off dynamically. The log format is database independent. Besides the SQL statement text, each log record contains information about the point in time when the statement was executed, its duration, its input parameters and results (where applicable) as well as context information.

Features

The SQL Trace is especially useful for:

· Development

SQL Trace can help JDO, enterprise beans, servlet and JSP developers to learn which kind of database accesses their code produces.

· Performance analysis

Typically, performance issues are caused by inefficient database accesses. In this case SQL Trace can be used to show the issued SQL statements and their duration, thus helping to identify inefficient SQL statements.

Activities

Typically, you should use the SQL Trace when you need to check the behavior of a particular application. This is the following scenario:

...

1. You launch the SQL Trace application.

2. You activate the SQL Trace.

3. You run the application that you want to trace.

4. You deactivate the SQL Trace.

5. You set filters optionally.

6. You evaluate the trace.

You can also evaluate a trace that already exists.

The SQL Trace also provides functions for file administration.

SQL Trace is less suitable for detecting general performance issues. Therefore, we do not recommend that you keep it constantly activated, as it consumes additional resources.

Rgds,

P.Naganjana Reddy