1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

Performance issue - Sequential Reads on Table ATP_RESB

Tuesday, 11 September 2012 09:30

Written by Bharathwaj Venkataramani

Print E-mail

Sometimes after a monthly maintenance, when creating PO’s and maintaining purchase orders, we had performance issues in the R/3 system. Further we could see too many work processes running for a long time and they were doing fetch operation on table ATP_RESB.

Our end users used to create/modify the POs just in 2 seconds, but in the above mentioned situations, it was taking more than 3 minutes.

We took the query at SAP level which was causing this issue and tried to execute the same at the DB level.  From SAP level it was taking the index Z~07 with an index scan and was taking more than a couple of minutes. Whereas from DB level it was completing inside 1 or 2 seconds using the index Z~06 by doing an index seek and not an index scan.  So in theory for some reason after the restart  because SAP started using the wrong index at the first attempt, this got cached and the same was being used every time.

Solution : We tried to rebuild the index Z~07 and immediately SAP started using the correct index ( Z~06)  and the performance issue was resolved

 

Performance issue - Sequential Reads on Table ATP_RESB