X hits on this document

161 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 views161
Page views161
Page last viewedSat Jan 21 23:49:37 UTC 2017
Pages48
Paragraphs862
Words4327

Comments