how to analyze performance problem

7/24/2019 How to Analyze Performance Problem

1/21

How to analyze performance problem

Performance Problem Guide Tips and Tricks

Purpose

Performance problem always happen during CO period end closing.

Its always not clear what to do when we meet performance problem.

This blog will guide you what to do with detailed steps.

Initial !nalysis

"ecessary Information

!fter you get a incident of performance issue# $rst you need to know below information%

&'hat is the program(T)code used*

&'hats the status of the +ob* Is it still running* How long ha,e it been running* 'hats the normal$nish time*

&Ha,e this issue happened before* If yes# how was it sol,ed*

&Is there any - update# /ernel update# support package update recently*

&Is the performance problem for this +ob only or system le,el*

Check 0ob with 1234

5irst of all# of course# you need to log on to the system.

1tep6. T)code% 1234 to check the +ob

The easy way to $nd the +ob is to use 0ob name.

7ou can also select the +ob according to status.
http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem


2/21

1ometimes the +ob names are identical# we need to $nd the e8act +ob by select the start condition.

1tep6. T)code% 1234 to check the +ob

The -uration time is the most important $gure in this page.

Click this button to show the log. 7ou can check whether there are any error messages.


3/21

Click Parameter# then click 29":)Goto);ariant to check the ,ariant this +ob is using. 1ee ne8t screen)sometimes the system you are using is with di?erent

time zone@

Click 29":)1ystem)1tatus..

Here is the current system time.


6/21

1chedule the +ob

Open a new session# and go to the T)code you want to trace and schedule the +ob.

Aemember to use background processing.

1et the e8ecution time. >!ccording to current system time@

Click Con$rm.


7/21

1chedule 1T6= trace

Go back to 1T6=

Click 29":):tilities)1chedule trace)5or atch+ob or workprocess

Input the +ob name in the last page.

If the +ob name is not identical# you can use Buser name and program name to

'e need to set the B5rom time according to the +ob start time. BTo time# set it to one hour later.

Change Inter,al to 6D sec

Input a meaningful Comment

!t last# press B1chedule trace


8/21

1chedule 1T6= trace

If the trace is successfully collected# you should be able to see below status in the trace list%

Go back to the initial screen of 1T6=# on the bottom of the page# you should be able to select and

check the trace result%


9/21

Check Trace Aesult

"ow click the B!!P trace button# below screen will show up%

Please check ne8t screen for detail e8planation.

!d,anced !nalysis

Check Trace Aesult

5irst# please check the time percentage bar.

&If !!P takes the most time# it should be program problem# which should be analyzed by the team

that owns the program. ut for performance issues which take long time# EDF of the issues are caused

by -.

&1o most of the time -atabase will take the most time. "ormally -atabase will show abo,e 4F of the

total time. In fact# if you get this result.

If you want to continue the analysis%

&5irst you can sort descending by "et time# then you can see the $rst line shows the Call which takes

the most time. "ormally this should be the cause for the performance problem.

&!s you can see in the e8ample# the time accessing table /9/O takes the most time. 1o $rst you can

try to search "otes with key words BProgram "ame BTable "ame Performance.

&7ou can click B-)


10/21

Check 98ecution Plan

7ou can see here are the list of rele,ant statements accessing table /9/O.

7ou can select the most e8pensi,e one and click button B98plain.

Check 98ecution Plan

Here you can see the e8ecution plan for this 1J statement%


11/21

Inde8

5irst we need to understand what is Inde8%

&'hen you look up businesses in a 7ellow Pages telephone book# you probably ne,er consider reading

the entire telephone book from co,er to co,er. 7ou more likely open the book somewhere in the middleand zero in on the reKuired business by searching back and forth a few times# using the fact that the

names are sorted alphabetically.

&One way for the database to deal with an unsorted table is by using a time)consuming seKuential

read) record by record. To sa,e the database from ha,ing to perform a seKuential read for e,ery 1J

statement Kuery# each database table has a corresponding primary inde8.

Then we need to understand the di?erence between Primary Inde8 and 1econdary Inde8%

&'e can consider the key $elds combination of a table is the Primary Inde8. 7ou can check with 1966

for each table to $nd its key $elds.

&! primary inde8 is always uniKueL that is# for each combination of inde8 $elds# there is only one table

entry.

&1ometimes the Primary Inde8 is not suMcient. 'e need to de$ne a 1econdary Inde8 that contains the

$elds we need. 7ou can also check 1econdary Inde8 with 1966 by clicking button BInde8esN.

&5or e8ample# 2aterial "umber is not a key $eld of table /9/O. If we want to search by 2aterial

"umber# we can de$ne a 1econdary Inde8 on the $eld 2aterial "umber. 'e can check in 1966#

/9/O! is the 1econdary Inde8 we talked about.

Aoot Cause

'e ha,e known how to check the e8ecution plan and the use of inde8es. "ow lets discuss the

causes of performance issue.

asically there are = kinds of issues%

&Inde8 is missing.

&'rong Inde8 is used.

>Testing can be performed ,ia 1TD ) 9nter 1J 1tatement@


12/21

Inde8 is missing.

5or e8ample# when search /9/O with QI55A# since its not in Primary Inde8 and no 1econdary Inde8

created# system need to make full table scan.

If the $eld QI55A contains a lot of uniKue ,alues# this full table scan will be ,ery time consuming.

1olution% -e$ne new 1econdary Inde8 for the table.

'rong Inde8 is used.

&1ometimes# although the correct inde8 e8ists# due to some reasons# the optimizer still chooses the

wrong inde8.

oThis might be cause by obsolete table statistics. 'hen there are changes to the table inde8es# table

statistics need to be updated manually.

o'ith some database >e.g. 211J1er,er@# the e8ecution plan doesnt change per each call# sometimes

it follows the last calls e8ecution plan. 1o there the wrong inde8 might be used.

1olutions%

&:pdate table statistics.

&Create - hints >Aeference "ote =DDRESR@


13/21

How to update table statistics

T)code% -D=

'hen 0ob is still running or not reproducible


14/21

0ob is still running.

!nalyze with 12D

&"ormally issue happens on one or two tables# when you keep refresh the screen# the table remains

the same. Then you should $nd out the statement and check the e8ecution plan.

&;ia 29":)!dministration)Program)-ebugging# you can start debugging and $nd out the statement

which is currently being read.

Trace with 1T6=

If the +ob is running for a long time and is still running. 7ou can do 1T6= trace for the +ob for a period

like we did in part I.

7ou can get the +ob details from 1234.


15/21

Check with 1T!-

If cant reproduce the issue again. 'e can check the status during +ob running time ,ia 1T!-.


16/21

7ou can check the result for B-atabase reKuest time.

6S3E ;iewsTopics%performanceTags% background#controlling# st6=#copc

!,erage :ser Aating

>6D ratings@
http://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=performancehttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=performancehttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=backgroundhttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=backgroundhttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=controllinghttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=controllinghttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=st12http://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=st12http://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=copchttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=copchttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=performancehttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=backgroundhttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=controllinghttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=st12http://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=copc


17/21

in1hareS

S Comments

Owen Jiu!pr =3# =D6 3%=E !2

'elcome your comments.

If you like it# please rate this blog or click Jike.

7ou in,ol,ement is my best moti,ity to create new resources.

Thank you allU

Jike >=@

o

1urya ;arma!pr =3# =D6 =%=S P2 >in response to Owen Jiu@

-ear Owen Jiu#

This indeed is really a ,ery good document. I wish i had it a little earlier >S months

before @# where a change >COP! -eri,ation Aule@ that was done by me has caused a

de,astating performance problem during COP! T--. I had no clue as to how to

analyze the reason. I felt like standing in front of a $ring sKuad who had all their guns

blazing at me. Thanks to my Team Jead and our asis team# who helped to sal,age

the situation for me that day.

Thanks to your document# god forbid but if i am in such a situation# i will be able to

put up a better and a bra,e face.

Thank you once again

est Aegards
http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/people/owen.liuhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-583238http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/people/suryavarma.cohttp://scn.sap.com/people/suryavarma.cohttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-583571http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-583238http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/people/owen.liuhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-583238http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/people/suryavarma.cohttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-583571http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-583238


18/21

1urya ;arma

Jike >6@

Owen Jiu!pr =E# =D6 =%6R !2>in response to 1urya ;arma@

-ear 1urya ;arma#

Thank you for your replyU I also felt the same before when I meet performance

issue. !s you know# we sometimes ha,e performance issue especially during

period end closing of Controlling. "ormally# the codings are stable# so most of

the time itVs - rele,ant issue. I always need to check with asis guys for the

same. ut after I ha,e some studies from them# I feel itVs not that diMcult to

make primary analysis. !t least# I can sol,e many performance issues withthis blog on my own.

IVm glad this blog can help you.

Cheers#

Owen

Jike >D@

o

;A/" 1i,aprasad A2ay 66# =D6 4%D P2 >in response to Owen Jiu@

"ice blog.. ,ery helpful.. keepup the good work.

Jike >D@

Actions

Loginto follow# like# comment# share and bookmark content.

Login Register
http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/people/owen.liuhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-584941http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-583571http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/people/sivaprasad.rhttp://scn.sap.com/people/sivaprasad.rhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-587586http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-583238http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/login.jspahttp://scn.sap.com/login.jspahttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/people/owen.liuhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-584941http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-583571http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/people/sivaprasad.rhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-587586http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problem#comment-583238http://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/login.jspahttp://scn.sap.com/login.jspa


19/21

Filter Blog

By author:

By date:


20/21

By tag:

beginner

businessWprocessWe8pert

co

co)pa

controlling

enterpriseWresourceWplanning erp

$co

$nance

$nancials

hana

productWcosting

sap

sapWerpW$nancials

scn
http://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=beginnerhttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=business_process_experthttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=cohttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=co-pahttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=controllinghttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=enterprise_resource_planninghttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=erphttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=ficohttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=financehttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=financialshttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=hanahttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=product_costinghttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=saphttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=sap_erp_financialshttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=scnhttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=beginnerhttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=business_process_experthttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=cohttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=co-pahttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=controllinghttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=enterprise_resource_planninghttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=erphttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=ficohttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=financehttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=financialshttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=hanahttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=product_costinghttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=saphttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=sap_erp_financialshttp://scn.sap.com/community/erp/financials/controlling/blog/tags#/?tags=scn


21/21

Recent Posts

Ae,aluate !cti,ity Type at !ctual Price

1teps for Indirect acti,ity determination and indirect acti,ity allocation using acti,ity category=

How is target cost calculated

Target cost is missing in production order How to delete unused /EAX tables generated by deri,ation rules.

Aoot cause for error CDSY ) 98ample for C!JJ 5:"CTIO" V!PIWGOO-12;TWCA9!T9V

How to analyze performance problem

:nderstanding the 1tandard Product Cost 9stimate

'hite Paper% !llocation Cycles Aelationship between 1ending & Aecei,ing Cost Centers and1egment & Cost Center 2apping

Technical approach to problem sol,ing as a reputation risk for global consultancies

Incoming Links

1!P !rchitecture 5ocus blogazine ) 2ay =D6

Follow SCN

Site Index

Contact Us

SAP Help Portal

Pri,acy

Terms of :se

Jegal -isclosure

Copyright
http://scn.sap.com/community/erp/financials/controlling/blog/2015/12/07/revaluate-activity-type-at-actual-pricehttp://scn.sap.com/community/erp/financials/controlling/blog/2015/11/11/steps-for-indirect-activity-determination-and-indirect-activity-allocation-using-activity-category-2http://scn.sap.com/community/erp/financials/controlling/blog/2015/11/11/steps-for-indirect-activity-determination-and-indirect-activity-allocation-using-activity-category-2http://scn.sap.com/community/erp/financials/controlling/blog/2015/08/19/how-is-target-cost-calculatedhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/08/18/target-cost-is-missing-in-production-orderhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/05/13/how-to-delete-unused-k9r-tables-generated-by-derivation-ruleshttp://scn.sap.com/community/erp/financials/controlling/blog/2015/05/07/root-cause-for-error-c048--example-for-call-function-bapigoodsmvtcreatehttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/19/understanding-the-standard-product-cost-estimatehttp://scn.sap.com/community/erp/financials/controlling/blog/2015/03/18/white-paper-allocation-cycles-relationship-between-sending-receiving-cost-centers-and-segment-cost-center-mappinghttp://scn.sap.com/community/erp/financials/controlling/blog/2015/03/18/white-paper-allocation-cycles-relationship-between-sending-receiving-cost-centers-and-segment-cost-center-mappinghttp://scn.sap.com/community/erp/financials/controlling/blog/2015/01/04/technical-approach-to-problem-solving-as-a-reputation-risk-for-global-consultancieshttp://scn.sap.com/community/netweaver/blog/2015/05/11/sap-architecture-focus-blogazine--may-2015http://scn.sap.com/docs/DOC-19361http://scn.sap.com/docs/DOC-18476http://help.sap.com/https://accounts.sap.com/ui/public/viewTextResource?scenario=SCN&spId=504efd8ee4b0555c3c17b94e&resourceType=RESOURCE_PRIVACYPOLICY&version=1&spDisplayName=SAP%20Community%20Networkhttps://accounts.sap.com/ui/public/viewTextResource?scenario=SCN&spId=504efd8ee4b0555c3c17b94e&resourceType=RESOURCE_TERMS_OF_USE&version=1&spDisplayName=SAP%20Community%20Network&locale=enhttp://www.sap.com/corporate-en/our-company/legal/impressum.epxhttp://www.sap.com/corporate-en/our-company/legal/copyright/index.epxhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/12/07/revaluate-activity-type-at-actual-pricehttp://scn.sap.com/community/erp/financials/controlling/blog/2015/11/11/steps-for-indirect-activity-determination-and-indirect-activity-allocation-using-activity-category-2http://scn.sap.com/community/erp/financials/controlling/blog/2015/11/11/steps-for-indirect-activity-determination-and-indirect-activity-allocation-using-activity-category-2http://scn.sap.com/community/erp/financials/controlling/blog/2015/08/19/how-is-target-cost-calculatedhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/08/18/target-cost-is-missing-in-production-orderhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/05/13/how-to-delete-unused-k9r-tables-generated-by-derivation-ruleshttp://scn.sap.com/community/erp/financials/controlling/blog/2015/05/07/root-cause-for-error-c048--example-for-call-function-bapigoodsmvtcreatehttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/21/how-to-analyze-performance-problemhttp://scn.sap.com/community/erp/financials/controlling/blog/2015/04/19/understanding-the-standard-product-cost-estimatehttp://scn.sap.com/community/erp/financials/controlling/blog/2015/03/18/white-paper-allocation-cycles-relationship-between-sending-receiving-cost-centers-and-segment-cost-center-mappinghttp://scn.sap.com/community/erp/financials/controlling/blog/2015/03/18/white-paper-allocation-cycles-relationship-between-sending-receiving-cost-centers-and-segment-cost-center-mappinghttp://scn.sap.com/community/erp/financials/controlling/blog/2015/01/04/technical-approach-to-problem-solving-as-a-reputation-risk-for-global-consultancieshttp://scn.sap.com/community/netweaver/blog/2015/05/11/sap-architecture-focus-blogazine--may-2015http://scn.sap.com/docs/DOC-19361http://scn.sap.com/docs/DOC-18476http://help.sap.com/https://accounts.sap.com/ui/public/viewTextResource?scenario=SCN&spId=504efd8ee4b0555c3c17b94e&resourceType=RESOURCE_PRIVACYPOLICY&version=1&spDisplayName=SAP%20Community%20Networkhttps://accounts.sap.com/ui/public/viewTextResource?scenario=SCN&spId=504efd8ee4b0555c3c17b94e&resourceType=RESOURCE_TERMS_OF_USE&version=1&spDisplayName=SAP%20Community%20Network&locale=enhttp://www.sap.com/corporate-en/our-company/legal/impressum.epxhttp://www.sap.com/corporate-en/our-company/legal/copyright/index.epx

how to analyze performance problem

Documents