How to run SAP transaction ST03/ST03N and navigate through SAP workload monitor screens July 2! 20"3 Posted on on July
ST03/ST03N is a SAP transaction for workload monitor used to review SAP workload distribution both from time vertically and servers horizontally. After you review my ost !SAP !SAP workload monitor overview" overview" you #et some idea on what this SAP tool is u for" now you wonder how to run SAP st03n and navi#ate throu#h fre$uent accessed ST03N screen. This is the focus of this ost% &. 'ow to star startt SAP worklo workload ad monitor monitor ST03N ST03N.. (. 'ow to navi#at navi#ate e throu#h throu#h SAP ST03N workload workload monitor monitor.. 'ow to understand ST03N data and what we can use ST03/ST03N for in SAP system/ro#ram/)ob erformance analysis would be covered in subse$uent ostin#. "# How to start SAP workload monitor ST03N To T o start SAP workload workload monitor" monitor" you can either either use menu ath or ath or run SAP transaction ST03/ST03N directly. The initial screen of workload monitor is similar to what showed in *i#ure & normally.
$igure " ST03 %nitial screen & Navigation 'anel and (verview o) instances
2# How to navigate through SAP ST03N workload monitor +ou + ou can navi#ate navi#ate throu#h throu#h SAP ST03N screens screens easily easily via via built,in navi#ation navi#ation lanel lanel showed in above *i#ure &. -n ST03N initial screen" you can access followin# functions% &.
orkl orkload oad ! So you you can ana analyze lyze SAP histo historica ricall workloa workload d for each each uni$e uni$e combination of eriod" alicati alication,server on,server or system" workload under this ortion are a##re#ated"
(.
etailed eta iled Ana Analysi lysis s ! So you you can analy analyze ze SAP cur curren rent1 t1 workloa workload d data whic which h can be drilled down to individual statistical record"
3.
2oad 2oa d history history and and istri istributi bution on ! So So you can coma comare re and and analy analyze ze erformance overall several eriods in one screen and
.
4ollecto 4oll ectorr and erfor erformanc mance e databa database se ! this this allows allows you you to de5ne de5ne reten retention tion eriod for di6erent erformance data collected. 7t also allow you to control what erformance statistical data should be make available for SAP work load ! business transaction analysis tool STA.
$igure " ST03 %nitial screen & Navigation 'anel and (verview o) instances
2# How to navigate through SAP ST03N workload monitor +ou + ou can navi#ate navi#ate throu#h throu#h SAP ST03N screens screens easily easily via via built,in navi#ation navi#ation lanel lanel showed in above *i#ure &. -n ST03N initial screen" you can access followin# functions% &.
orkl orkload oad ! So you you can ana analyze lyze SAP histo historica ricall workloa workload d for each each uni$e uni$e combination of eriod" alicati alication,server on,server or system" workload under this ortion are a##re#ated"
(.
etailed eta iled Ana Analysi lysis s ! So you you can analy analyze ze SAP cur curren rent1 t1 workloa workload d data whic which h can be drilled down to individual statistical record"
3.
2oad 2oa d history history and and istri istributi bution on ! So So you can coma comare re and and analy analyze ze erformance overall several eriods in one screen and
.
4ollecto 4oll ectorr and erfor erformanc mance e databa database se ! this this allows allows you you to de5ne de5ne reten retention tion eriod for di6erent erformance data collected. 7t also allow you to control what erformance statistical data should be make available for SAP work load ! business transaction analysis tool STA.
Please refer to 5#ure ( for a brief descrition on navi#ation otions. 7 would cover more details in followin# sections.
$igure 2 ST03N workload navigation o'tion overview
-nly entries startin# with
in ST03N reresents an e8ecutable function. +ou
need to click 1 or 1 icon to see 1
entry1 in navi#ation anel. To start a
ST03N function via ST03N navi#ation anel" you need to double click on a entry like
in *i#ure (.
2#" SAP *orkload +eview ST03N or#anizes workload data into di6erent views/ro5les to facilitate erformance analysis. ata in each workload view is or#anized into di6erent tabs based on erformance focus. A workload view can be available for one eriod or one server/instance "but not available in another eriod or server when underlyin# data is not available. ata is not available due to two reasons% data is deleted and data has not been collected. +ou can make roer settin# via ST03N or system arameter maintenance transaction 9:&& to control data collection and retention. *or e8amle" you do not see
view in the lower ortion of
navi#ation anel showed in *i#ure 3. 7 would talk more in later ortion of this ost.
2#"#" SAP *(+,-(A. (+%* S1+N
ata from SAP workload overview screen allows you to analyze SAP erformance at system/server and task tye level. Now assumin# that 7 need to review workload situation at system level ;T-TA2< for a articular day" so 7 click the Total1 entry 5rst" then ay1 entry" i double clicked the date !here =une &> (0&3" Screen similar to *i#ure 3 would show u.
$igure 3 ST03N *orkload (verview screen
Please note the main dislay has 3 comonents%
Part & is navi#ation anel. orkload navi#ation anel has two ortions ! the uer ortion is the ST03N transaction ori#inal navi#ation anel" the
lower ortion shows a list of available analysis views for SAP workload analysis.
Part ( is workload header information ! showin# eriod ;a customer eriod" a day" a week or a month< where workload is related" instance ;a seci5c instance or total< and task tye ;a seci5c task tye or all<. Please double check with & records and last records and time eriod 5eld to st
ensure that you #ot all workload from the eriod you selected.
Part 3 is workload details.
*orkload over view screen is the initial view 'resented y ST03N )or load analysis# The workload overview shows times statistics consolidated according to SAP task ty'es# %n a SAP 11 system! .ialog! ackground! +$1! A- and 4'dating task 'er)ormance are most critical to usiness )unction# *orkload overview screen 'rovides a 'er)ormance overview on task ty'e level#
There are several tabs in orkload overview to hel you to $uickly locate the data you mi#ht need. The user tab shows number of accumulated users from the system/instance for the selected eriod. %n the le)t ottom corner o) $igure 3 is a list o) analysis views availale )or the workload in the selected 'eriod and server sco'e# 5ou can navigate to any view y moving your cursor and doule clicking the view like 6standard7 under 6Transaction Pro8le7#
2#"#2 ST03N T+ANSA1T%(N P+($%-
ata from transaction ro5le allows you to do alication erformance analysis. There are two versions of transaction ro5le ! one is Standard1" the other is ?arlyatch1. Standard ro5le has more navi#ation feature and rovides workload breakdown based on SAP task tyes.
ouble click Standard1 under transaction Pro5le1" +ou would #et screen similar to 5#ure
$igure 9 SAP workload & standard transaction 'ro8le
7n 5#ure " All data1 tab is or#anized into several child tabs ! Times" atabase" Parts of resonse time" @7 times with default tab Times1 dislayed. @7 Times tab is only alicable to ialo# tye task.
?arlyatch transaction ro5le is similar to standard1 transaction ro5le. The di6erence between them is that ?arlyatch consolidates workload dislayed in *i#ure based on the & column ! 9eort or Transaction name1. This hels if st
you want to know to load ro#rams in the system. Tale " & *orkload view navigation uttons
+our #oal
Button should be clicked
4omment
*ilter dislay by task tye
+ou select corresondin# task tye1 from the ull,down menu which has ialo#1" BA4C@9-N1" 9*41 and etc. +ou can select ialo#1 task tye so only online e8ecuted transactions are dislayed.
A##re#ate workload
This allows you to a##re#ate workload on one of SAP rede5ned levels% Alication such as 4-" 2?" DD" *7 and etc" Subalication like DD,7D" DD,P9 etc " acka#e and transaction. efault level is transaction.
4heck individual statistical records
To use this" you need to lace cursor on selected row 5rst. This works only with current data1 while STA works. 4urrent data is normally referrin# to data related to transaction e8ecuted in recent E hours.
4heck 4olumn full name
2on#,short name to #ive you more meanin# of the column or save the column width.
*ilter dislay by column
*ilter dislay based on column like isk reads" Pro#ram name etc. +ou can click a column 5rst or you can select columns for sortin# from available 5elds after you click the 5lter button.
Sort dislay
Sort in Ascendin# or escendin# in e8ected column. 4lick the column name 5rst before the sort button is clicked.
Search on the screen
+ou can search the dislay based on seci5c value from any column.
Summarize
+ou need to select the numeric column like
numeric column
F stes1" then click this button
?8ort the dislay to a local 5le
Save dislayed workload data to local 5le.
4han# dislay
+ou can control what column should be dislayed and their osition and save it for future use.
The same button has the same usa#e re#ardless of ST03N analyst views you are workin# with althou#h some buttons are only alicable to seci5c views like sin#le records1 button which is not available in workload default view ! workload overview.
2#"#2 ST03N T%: P+($%-
ata from ST03N time ro5le view allows you to analyze erformance/load di6erence between di6erent hours. ouble click Time Pro5le1 entry in navi#ation anel ;see *i#ure 3<" you would see screen similar to 5#ure G.
$igure ; ST03N SAP workload time 'ro8le
Time ro5le searates workload from a eriod ; a day" a week or a month< into hourly fashion. So you can know the busiest hours in terms of workload. 7f your dislay is not in hourly fashion" you mi#ht need to refer to followin# ossnote %
&>>G0 workload% time ro5le also for ni#ht hours and
H&0EH> ST03N% 4on5#uration of time ro5le.
2#"#3 ST03N +$1 P+($%-S & +$1 S++ P+($%-
ata from ST03n 9*4 ro5les allows you to analyze 9*4 erformance. +ou can use ST03N to review 9*4 workload. 9*4 workload is further searated into 9*4 client ro5le" 9*4 server ro5le" 9*4 4lient estination and 9*4 Server estination ro5le. This makes it easier for you to do seci5c workload analysis.
$igure ST03N & +$1 Server 'ro8le
9*4 Server estination ro5le
$igure < ST03N & .estination 'ro8le
2#"#9 SAP ST03N +SP(NS T%: .%ST+%4T%(N %*
ata from this view can allow you to see transaction ste distribution based on duration. ouble click 9esonse Time istribution1 entry in workload navi#ation anel" you would #et screen like *i#ure ,E.
$igure = ST03N +es'onse Time .istriution
Number of dialo# stes under & second is often used to measure a system erformance based on I of dialo# resonse time under & seconds.
2#"#; SAP ST03N & (TH+ *(+,-(A. ANA-5S%S %*S
+ou can navi#ate to other workload analysis views like Demory se Statistics" 9ankin# lists" ser and Settlement Stat etc in the same fashion. +ou mi#ht need to review those views based on seci5c situation ! for e8amle" if you would like
to tune memory usa#e and need to identify to memory consumer" ST03N orkload ! Demory se Statistics view is a #ood lace to start. 2#2 .etailed Analysis 'ere" you can analyze current1 workload which mi#ht not show u in workload analysis we have covered in revious section of this ost" you can access individual SAP statistical record via
button showed in 5#ure .
2#2#" 4S%NSS T+ANSA1T%(N ANA-5S%S
4lick this entry" it would start SAP STA transaction #ivin# you access to recent individual erformance statistical records. +ou can refer to my ost on how to run SAP STA transaction. 2#2#2 -AST :%N4T>S -(A.
To see last minuteJs workload" you need to click a server or total; whole system< " inut the data and then hit the e8ecution or continue key. Please refer to *i#ure K with inut data. Time ro5le #ranularity1 mi#ht be helful for you to or#anize workload data into #ood1 eriod and bad1 eriod for easy comarison in erformance analysis.
$igure ? ST03N last minute>s -oad initial screen
After you enter your data and hit e8ecution" you would #et all normal views we covered in workload1 section of this osts and you can access those workload views in the same way which is covered in workload section of this ost. hen 7 hit -C1 or continue button in 5#ure K" 7 #ot a workload1 overview screen normally. 'owever 7 resented 1 time ro5le1 view of workload in *i#ure > as an e8amle.
$igure "0 ST03N last minute>s load & time 'ro8le
?ach time you run SAP ST03N to review workload for selected server/instance" the default view would be workload overview. 'owever if you would like to review workload in another server etc." the default view is the last analysis view you review with revious workload analysis. 2#3 *orkload History and .istriution 7n this section" three analysis otions are available
2oad history"
7nstance 4omarison and
sers er 7nstance.
+ou use navi#ation anel to access those analysis otion by clickin# corresondin# leaf entry.
2 # 3 # " S T 0 3 N - ( A . H % S T ( +5
ata from load history view allows you to analyze erformance trend of a SAP system/alication/task tyes.
+ou can review workload history of sin#le instance/server or workload history of whole system. 7f you double click on total1 entry" you would #et workload history screen similar to *i#ure E.
$igure "" ST03N workload history at system level
4lick button Task tye1 in 5#ure &&" you can review workload for the e8ected workload tye. 4lick eek and Donth button in *i#ure &&" Number of stes would be summarized and resonse time would be avera#ed in e8ected time interval.
2#3#2 %NSTAN1 1(:PA+%S(N
ata from instance comarison allows you to analyze erformance amon# di6erent instances. orkload data in di6erent alication server can be comared in day" week and month interval. Please refer to 5#ure &( for navi#ation ath.
$igure "2 ST03N %nstance com'arison
2#3#3 4S+S P+ %NSTAN1
ouble click ser er 7nstance 1 under ath ST03N ,L 2oad 'istory and istribution1" you would see screen similar to *i#ure &3.
$igure "3 ST03N 4sers 'er instance
2#9 1ollector and 'er)ormance . 'ere" SAP ST03N allows you to de5ne retention eriod for data used in SAP ST03N. 7t also allows you to have control over some online arameters which control statistical sub,record #eneration or collections temorarily. Those online arameter chan#es could be lost or relaced by the value from sever/instance ro5le. Please refer to *i#ure & for function details
2#9#" .$%N .ATA AN. *(+,-(A. +%* +TNT%(N P+%(.
ouble click on 9eor#anization1 under ath SAP ST03N ,L 4ollector and Performance B ,L Performance atabase ,LDonitorin# atabase1" +ou would see screen similar to
$igure "; Per)ormance dataase retention 'eriod
+ou can overwrite the those number based on your seci5c need. ouble click on 4ontrol1 under ath ST03N ,L 4ollector and Performance B ,L Performance atabase ,L orkload 4ollector atabase ,L 9eor#anization1" +ou would see screen similar to
$igure " & SAP ST03N workload collector views retention 'eriod
'ere you can de5ne retention eriod for Daily/Weekly/Monthly Aggregates Retention Period workload data for seci5c view. 7n 5#ure &K" daily a##re#ates data would
be ket for & days only ! after they would be deleted automatically. 2#9#2 STAT%ST%1S +1(+.S & (N-%N PA+A:T+S
ST03N allows you to chan#e online arameters to inMuence statistics data #eneration on the My ! you navi#ate to the screen" overwrite the data and save the chan#es. +our chan#es come into e6ect immediately uon savin#. 7t can be lost immediately after the system is reboot/restarted as well. ouble 4lick ialo# Ste Statistics1 under ath ST03N,L 4ollector and Performance B ,L Statistics 9ecords *ile,L-nline Parameters1" you would see followin# screen
$igure "< ST03N online 'arameters o) Statistics
Please note those chan#es are alied to all task tyes in the server where it is e6ected not )ust alicable to online transactions. 7f you would like to see what are to 3 tables which a transaction ste sends itsJ time on" you can overwrite value to 3O under arameter STAT/TAB9?41 column in 5#ure &>. 7f you are only interested in to 3 table for a seci5c business transaction like order creation transaction A0&O" you can enter A0&O under stat/tcode&O column" otherwise the settin# would be e6ect for all transactions. There are #eneral SAP #uidelines/default values for those arameters. 9emember it is a load to system to #enerate and collect statistics" set it u when there is a real need. A blank or :ero1 means that corresondin# statistics are not collected. 3 $urther clari8cation 7 have not navi#ated to all screens/features under SAP transaction ST03N to kee the ost short. But Dost of fre$uent accessed ST03N views and features has been dislayed here base on my e8erience so far. sin# navi#ation anel of ST03N" you should be able to navi#ate to other screens you are interested. Dy subse$uent ost would talk on how to understand the ST03N data and what SAP ST03N can do for erformance analysis.
ST03/ST03N is a SAP transaction for workload monitor used to review SAP workload distribution both from time vertically and servers horizontally. After you review my ost !SAP workload monitor overview" you #et some idea on what this SAP tool is u for" now you wonder how to run SAP st03n and navi#ate throu#h fre$uent accessed ST03N screen. This is the focus of this ost% &. 'ow to start SAP workload monitor ST03N. (. 'ow to navi#ate throu#h SAP ST03N workload monitor. 'ow to understand ST03N data and what we can use ST03/ST03N for in SAP system/ro#ram/)ob erformance analysis would be covered in subse$uent ostin#. "# How to start SAP workload monitor ST03N To start SAP workload monitor" you can either use menu ath or run SAP transaction ST03/ST03N directly. The initial screen of workload monitor is similar to what showed in *i#ure & normally.
$igure " ST03 %nitial screen & Navigation 'anel and (verview o) instances
2# How to navigate through SAP ST03N workload monitor
+ou can navi#ate throu#h SAP ST03N screens easily via built,in navi#ation lanel showed in above *i#ure &. -n ST03N initial screen" you can access followin# functions% &.
orkload ! So you can analyze SAP historical workload for each uni$e combination of eriod" alication,server or system" workload under this ortion are a##re#ated"
(.
etailed Analysis ! So you can analyze SAP current1 workload data which can be drilled down to individual statistical record"
3.
2oad history and istribution ! So you can comare and analyze erformance overall several eriods in one screen and
.
4ollector and erformance database ! this allows you to de5ne retention eriod for di6erent erformance data collected. 7t also allow you to control what erformance statistical data should be make available for SAP work load ! business transaction analysis tool STA.
Please refer to 5#ure ( for a brief descrition on navi#ation otions. 7 would cover more details in followin# sections.
$igure 2 ST03N workload navigation o'tion overview
-nly entries startin# with
in ST03N reresents an e8ecutable function. +ou
need to click 1 or 1 icon to see 1
entry1 in navi#ation anel. To start a
ST03N function via ST03N navi#ation anel" you need to double click on a entry like
in *i#ure (.
2#" SAP *orkload +eview ST03N or#anizes workload data into di6erent views/ro5les to facilitate erformance analysis. ata in each workload view is or#anized into di6erent tabs based on erformance focus. A workload view can be available for one eriod or one server/instance "but not available in another eriod or server when underlyin# data is not available. ata is not available due to two reasons% data is deleted and data has not been collected. +ou can make roer settin# via ST03N or system arameter maintenance transaction 9:&& to control data collection and retention. *or e8amle" you do not see
view in the lower ortion of
navi#ation anel showed in *i#ure 3. 7 would talk more in later ortion of this ost.
2#"#" SAP *(+,-(A. (+%* S1+N
ata from SAP workload overview screen allows you to analyze SAP erformance at system/server and task tye level. Now assumin# that 7 need to review workload situation at system level ;T-TA2< for a articular day" so 7 click the Total1 entry 5rst" then ay1 entry" i double clicked the date !here =une &> (0&3" Screen similar to *i#ure 3 would show u.
$igure 3 ST03N *orkload (verview screen
Please note the main dislay has 3 comonents%
Part & is navi#ation anel. orkload navi#ation anel has two ortions ! the uer ortion is the ST03N transaction ori#inal navi#ation anel" the
lower ortion shows a list of available analysis views for SAP workload analysis.
Part ( is workload header information ! showin# eriod ;a customer eriod" a day" a week or a month< where workload is related" instance ;a seci5c instance or total< and task tye ;a seci5c task tye or all<. Please double check with & records and last records and time eriod 5eld to st
ensure that you #ot all workload from the eriod you selected.
Part 3 is workload details.
*orkload over view screen is the initial view 'resented y ST03N )or load analysis# The workload overview shows times statistics consolidated according to SAP task ty'es# %n a SAP 11 system! .ialog! ackground! +$1! A- and 4'dating task 'er)ormance are most critical to usiness )unction# *orkload overview screen 'rovides a 'er)ormance overview on task ty'e level#
There are several tabs in orkload overview to hel you to $uickly locate the data you mi#ht need. The user tab shows number of accumulated users from the system/instance for the selected eriod. %n the le)t ottom corner o) $igure 3 is a list o) analysis views availale )or the workload in the selected 'eriod and server sco'e# 5ou can navigate to any view y moving your cursor and doule clicking the view like 6standard7 under 6Transaction Pro8le7#
2#"#2 ST03N T+ANSA1T%(N P+($%-
ata from transaction ro5le allows you to do alication erformance analysis. There are two versions of transaction ro5le ! one is Standard1" the other is ?arlyatch1. Standard ro5le has more navi#ation feature and rovides workload breakdown based on SAP task tyes.
ouble click Standard1 under transaction Pro5le1" +ou would #et screen similar to 5#ure
$igure 9 SAP workload & standard transaction 'ro8le
7n 5#ure " All data1 tab is or#anized into several child tabs ! Times" atabase" Parts of resonse time" @7 times with default tab Times1 dislayed. @7 Times tab is only alicable to ialo# tye task.
?arlyatch transaction ro5le is similar to standard1 transaction ro5le. The di6erence between them is that ?arlyatch consolidates workload dislayed in *i#ure based on the & column ! 9eort or Transaction name1. This hels if st
you want to know to load ro#rams in the system. Tale " & *orkload view navigation uttons
+our #oal
Button should be clicked
4omment
*ilter dislay by task tye
+ou select corresondin# task tye1 from the ull,down menu which has ialo#1" BA4C@9-N1" 9*41 and etc. +ou can select ialo#1 task tye so only online e8ecuted transactions are dislayed.
A##re#ate workload
This allows you to a##re#ate workload on one of SAP rede5ned levels% Alication such as 4-" 2?" DD" *7 and etc" Subalication like DD,7D" DD,P9 etc " acka#e and transaction. efault level is transaction.
4heck individual statistical records
To use this" you need to lace cursor on selected row 5rst. This works only with current data1 while STA works. 4urrent data is normally referrin# to data related to transaction e8ecuted in recent E hours.
4heck 4olumn full name
2on#,short name to #ive you more meanin# of the column or save the column width.
*ilter dislay by column
*ilter dislay based on column like isk reads" Pro#ram name etc. +ou can click a column 5rst or you can select columns for sortin# from available 5elds after you click the 5lter button.
Sort in Ascendin# or escendin# in e8ected column. 4lick the column name 5rst before the sort button is clicked.
Sort dislay
Search on the screen
+ou can search the dislay based on seci5c value from any column.
Summarize numeric column
+ou need to select the numeric column like F stes1" then click this button
?8ort the dislay to a local 5le
Save dislayed workload data to local 5le.
4han# dislay
+ou can control what column should be dislayed and their osition and save it for future use.
The same button has the same usa#e re#ardless of ST03N analyst views you are workin# with althou#h some buttons are only alicable to seci5c views like sin#le records1 button which is not available in workload default view ! workload overview.
2#"#2 ST03N T%: P+($%-
ata from ST03N time ro5le view allows you to analyze erformance/load di6erence between di6erent hours. ouble click Time Pro5le1 entry in navi#ation anel ;see *i#ure 3<" you would see screen similar to 5#ure G.
$igure ; ST03N SAP workload time 'ro8le
Time ro5le searates workload from a eriod ; a day" a week or a month< into hourly fashion. So you can know the busiest hours in terms of workload. 7f your dislay is not in hourly fashion" you mi#ht need to refer to followin# ossnote %
&>>G0 workload% time ro5le also for ni#ht hours and
H&0EH> ST03N% 4on5#uration of time ro5le.
2#"#3 ST03N +$1 P+($%-S & +$1 S++ P+($%-
ata from ST03n 9*4 ro5les allows you to analyze 9*4 erformance. +ou can use ST03N to review 9*4 workload. 9*4 workload is further searated into 9*4 client ro5le" 9*4 server ro5le" 9*4 4lient estination and 9*4 Server estination ro5le. This makes it easier for you to do seci5c workload analysis.
$igure ST03N & +$1 Server 'ro8le
9*4 Server estination ro5le
$igure < ST03N & .estination 'ro8le
2#"#9 SAP ST03N +SP(NS T%: .%ST+%4T%(N %*
ata from this view can allow you to see transaction ste distribution based on duration. ouble click 9esonse Time istribution1 entry in workload navi#ation anel" you would #et screen like *i#ure ,E.
$igure = ST03N +es'onse Time .istriution
Number of dialo# stes under & second is often used to measure a system erformance based on I of dialo# resonse time under & seconds.
2#"#; SAP ST03N & (TH+ *(+,-(A. ANA-5S%S %*S
+ou can navi#ate to other workload analysis views like Demory se Statistics" 9ankin# lists" ser and Settlement Stat etc in the same fashion. +ou mi#ht need to review those views based on seci5c situation ! for e8amle" if you would like
to tune memory usa#e and need to identify to memory consumer" ST03N orkload ! Demory se Statistics view is a #ood lace to start. 2#2 .etailed Analysis 'ere" you can analyze current1 workload which mi#ht not show u in workload analysis we have covered in revious section of this ost" you can access individual SAP statistical record via
button showed in 5#ure .
2#2#" 4S%NSS T+ANSA1T%(N ANA-5S%S
4lick this entry" it would start SAP STA transaction #ivin# you access to recent individual erformance statistical records. +ou can refer to my ost on how to run SAP STA transaction. 2#2#2 -AST :%N4T>S -(A.
To see last minuteJs workload" you need to click a server or total; whole system< " inut the data and then hit the e8ecution or continue key. Please refer to *i#ure K with inut data. Time ro5le #ranularity1 mi#ht be helful for you to or#anize workload data into #ood1 eriod and bad1 eriod for easy comarison in erformance analysis.
$igure ? ST03N last minute>s -oad initial screen
After you enter your data and hit e8ecution" you would #et all normal views we covered in workload1 section of this osts and you can access those workload views in the same way which is covered in workload section of this ost. hen 7 hit -C1 or continue button in 5#ure K" 7 #ot a workload1 overview screen normally. 'owever 7 resented 1 time ro5le1 view of workload in *i#ure > as an e8amle.
$igure "0 ST03N last minute>s load & time 'ro8le
?ach time you run SAP ST03N to review workload for selected server/instance" the default view would be workload overview. 'owever if you would like to review workload in another server etc." the default view is the last analysis view you review with revious workload analysis. 2#3 *orkload History and .istriution 7n this section" three analysis otions are available
2oad history"
7nstance 4omarison and
sers er 7nstance.
+ou use navi#ation anel to access those analysis otion by clickin# corresondin# leaf entry.
2 # 3 # " S T 0 3 N - ( A . H % S T ( +5
ata from load history view allows you to analyze erformance trend of a SAP system/alication/task tyes.
+ou can review workload history of sin#le instance/server or workload history of whole system. 7f you double click on total1 entry" you would #et workload history screen similar to *i#ure E.
$igure "" ST03N workload history at system level
4lick button Task tye1 in 5#ure &&" you can review workload for the e8ected workload tye. 4lick eek and Donth button in *i#ure &&" Number of stes would be summarized and resonse time would be avera#ed in e8ected time interval.
2#3#2 %NSTAN1 1(:PA+%S(N
ata from instance comarison allows you to analyze erformance amon# di6erent instances. orkload data in di6erent alication server can be comared in day" week and month interval. Please refer to 5#ure &( for navi#ation ath.
$igure "2 ST03N %nstance com'arison
2#3#3 4S+S P+ %NSTAN1
ouble click ser er 7nstance 1 under ath ST03N ,L 2oad 'istory and istribution1" you would see screen similar to *i#ure &3.
$igure "3 ST03N 4sers 'er instance
2#9 1ollector and 'er)ormance . 'ere" SAP ST03N allows you to de5ne retention eriod for data used in SAP ST03N. 7t also allows you to have control over some online arameters which control statistical sub,record #eneration or collections temorarily. Those online arameter chan#es could be lost or relaced by the value from sever/instance ro5le. Please refer to *i#ure & for function details
2#9#" .$%N .ATA AN. *(+,-(A. +%* +TNT%(N P+%(.
ouble click on 9eor#anization1 under ath SAP ST03N ,L 4ollector and Performance B ,L Performance atabase ,LDonitorin# atabase1" +ou would see screen similar to
$igure "; Per)ormance dataase retention 'eriod
+ou can overwrite the those number based on your seci5c need. ouble click on 4ontrol1 under ath ST03N ,L 4ollector and Performance B ,L Performance atabase ,L orkload 4ollector atabase ,L 9eor#anization1" +ou would see screen similar to
$igure " & SAP ST03N workload collector views retention 'eriod
'ere you can de5ne retention eriod for Daily/Weekly/Monthly Aggregates Retention Period workload data for seci5c view. 7n 5#ure &K" daily a##re#ates data would
be ket for & days only ! after they would be deleted automatically. 2#9#2 STAT%ST%1S +1(+.S & (N-%N PA+A:T+S
ST03N allows you to chan#e online arameters to inMuence statistics data #eneration on the My ! you navi#ate to the screen" overwrite the data and save the chan#es. +our chan#es come into e6ect immediately uon savin#. 7t can be lost immediately after the system is reboot/restarted as well. ouble 4lick ialo# Ste Statistics1 under ath ST03N,L 4ollector and Performance B ,L Statistics 9ecords *ile,L-nline Parameters1" you would see followin# screen
$igure "< ST03N online 'arameters o) Statistics
Please note those chan#es are alied to all task tyes in the server where it is e6ected not )ust alicable to online transactions. 7f you would like to see what are to 3 tables which a transaction ste sends itsJ time on" you can overwrite value to 3O under arameter STAT/TAB9?41 column in 5#ure &>. 7f you are only interested in to 3 table for a seci5c business transaction like order creation transaction A0&O" you can enter A0&O under stat/tcode&O column" otherwise the settin# would be e6ect for all transactions. There are #eneral SAP #uidelines/default values for those arameters. 9emember it is a load to system to #enerate and collect statistics" set it u when there is a real need. A blank or :ero1 means that corresondin# statistics are not collected.
