The program was moving UNIX files around. The source code position that I arrived at didn't seem to be doing anything other than an OPENSQL statement, so I scrolled back up the program a little. I single clicked the first record after the time gap, and because it was an ABAP program, I was able to click the " Display Call Positions in ABAP Programs" button: Sorting the trace by the "Time" column and manually scrolling through looking for the 5 seconds between one row and the next and sure enough, I found it. In fact, the total duration of the trace period didn't add up to even 1 second. I found that there were no long durations in the entire trace. So I had an opportunity to display these traces for the same period of time (and the same Work Process number). It just so happens that at the same time as this STAD record was created, I was also running an Enqueue Trace, SQL Trace and Buffer Trace from transaction ST05 (yeah, it was a quiet day so I felt confident that dipping in and out of tracing wouldn't hurt performance too bad). One of the records (shown below) has a huge "Roll Wait" time of around 5 seconds, yet "GUI Time" is zero: The database time looked reasonable ( "GUI Time" with 0 "RFC+CPIC". The worst performing reports were customer developed reports. I brought up the ST03 screen and checked the " Ranking Lists -> Top Response Time of Dialog Steps" (also known as the Hit List) for the past 3 month's data, one month at a time.Īll three months showed a similar pattern. SLAs are monitored against DIALOG response time from 9am to 6pm weekdays only. After all, this does seem to be the case in ~75% of the cases I've seen.īasic info: SAP NW 702 on Oracle 11gR2 on Unix. I initially thought this was going to a be a nice easy assignment, identify the database performance issues and propose some reorganisation work. They use the EarlyWatch Report to monitor the SAP system SLAs against response time performance. One of my clients identified an increase in the Response Time measurements they monitor.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |