cancel
Showing results for 
Search instead for 
Did you mean: 

Performance Issue

Former Member
0 Kudos

Hi,

All the dialog processes are consumed by a report run. Report ZCL_MSG_LO is running in dialog but with a batch user and making direct read on table ZCNR_INT_L. Hence making a performance issue.

Please help me out ASAP.

Accepted Solutions (1)

Accepted Solutions (1)

smartinezav
Discoverer
0 Kudos

Hi Suman,

If you are in a hurry, maybe the fast solution is to activate a full performance trace (SQL, Enqueue, RFC and Table Buffer) for this report or user, just at the corresponding pre-production system. Here, you can see the worst execution points and analyze which could be the cause.

So, if you have more time, you'd better to analyze the performance statistics information of the report over a period of time (daily, weekly, monthly, along the year) to try to find the causes of the problem: CPU bottlenecks, communication problems, expensive database access or expensive ABAP processing.

Kind regards,

Susana

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Suman,

I would recommend to use solution manager to tune this particular statement.

There is a self service 'SQL Tuning Advisor' available in SolMan 7.0 SP23 onwards which suggests

It's own recommendation for the particular statement.

Moreover, you can use SQL advisor from oracle to investigate the cost estimation and it recommends

Generic solutions as well.

You can check the data in tcode STAD for this particular program. It doesn't store the data ver long so, check

Immediately when this report is executed. You can check the max time consumed area for this run.

Then you can see if creation if indexes help in reducing the search area for sql query in this custom report.

Regards,

Ankit

Former Member
0 Kudos

Looks like you need to create an index or analyze statistics..

Former Member
0 Kudos

Make a trace on the program from st12 and and get the glance of the explain how the cost is for the results and type of scanning on tables, if you observe any full scan create an index on key fields.

Check the workload from st03 transaction and check the distubution of response time where it was taking more time, if it takes most of the db time then tune the querys on the tables .

Former Member
0 Kudos

Suman

Check if the statistics are upto date so that it takes best path to read the table.

Look through ST03N where is it taking more time and involve respective team accordingly

Engage ABAP and DBA team as well to do further analysis.

Cheers !

Manish Jain

Former Member
0 Kudos

Hi

Can you ues "DBacockpit --> Sql Statement analysis --> sahred cursor cashe" in order to analyse the SQl request . abnd find if there are no bizzar coding .

From name is a developed module . ( with developer some time you can find request to optimize )

BR

Edited by: choaib tahir on Oct 23, 2011 5:20 PM