ST03 Explanation and its Analysis queries

[Mithran]

Dear Guru's

I came across in a situation where Dialog Response time for specific duration for example <1s only for one day in week, say Wednesday is getting 80%. for other days response time for <1s is good its 90%.

How to track for only Wednesday, when I see time frame there are 3 time frames where response time is lesser than 90%. Time Frame: 00-06, 7-8, 12-13.

How to finalize it, like i should check based on Number of steps? or Response time or roll+wait time.

Also could you please help me in the part of roll+wait time? what is that. its between roll in and roll out?

any examples with any transaction? From initial to last step.

Things I know how to check st03 based on response time:

Database response time<= 40% of response time is good. more than that have to check at DB

CPU <=40% response time

what about sequential reads & direct reads?

what is Number of round trips how to calculate it ? roundtrip is something between GUI and SAP Application but how to get a formula or a better understanding of it?

for example: if i execute any transaction like sm51 or st22? how many roundtrips will be involved?

In some cases i could see steps are less and database time also less but average response time is huge how to calculate it?

I came across few blogs but few i could understand like Database & CPU Response time.

Kindly do the needful.

Thanks & Regards,

Mithran

[S_Sriram]

Hi Mithran

1. In the MS SQL database data & log files are in the same or different folders? just refer to the SAP help portal link

https://help.sap.com/saphelp_scm700_ehp01/helpdata/ru/f2/31ad3e810c11d288ec0000e8200722/content.htm?...

2. Every day after the database backup, are you performing the log truncate backup? to get the better performance of DB.

Regards

SS

[S_Sriram]

Hi Mithan

1. You can check the overall number of users, transactions, & background jobs on Wednesday and other days? what is the status of transaction code ST02? during the weekdays are restarting the SAP instance?

2. For an end to end transaction details steps and performance analysis you can use the traction code STAD, refer to the blog it may help you, https://blogs.sap.com/2013/06/11/how-to-use-stad-to-show-historical-data/

3. Could you share your OS/DB & SAP version details? based on that we can advice you.

Regards

SS

[Mithran]

Hi S Sriram,

Thanks a lot for your reply.

OS/DB and SAP Version Details:
DB Version: MS SQL 13.00.44
OS: Windows
SAP NetWeaver 7.5 SP 11

Kernel:749 patch level 1000.

Last restart happened 2 weeks ago.

Thanks & Regards,

Mithran