X hits on this document

121 views

0 shares

0 downloads

0 comments

21 / 48

Microsoft’s SAP ERP (R/3) System (cont)

Query caching issues:

SAP does execute every query as parameterized statement in order to get query cached and re-used

Beneficial in most of the cases

However individual issues in individual customers where:

Two indexes are possible to be chosen

Data in some tables or columns is skewed

‘First’ caller submits non-typical parameter set

Issues result in:

Some functionality of application running slow for extended period of time (hours or whole day)

Disk Subsystem being hammered by I/O requests

DBA-416M• ISV configurations & implementations – Lessons Learned

Document info
Document views121
Page views121
Page last viewedSat Dec 10 08:17:49 UTC 2016
Pages48
Paragraphs862
Words4327

Comments