Answer Posted / pranay
Every SAP instance has various buffers, in which data to be
accessed by users is stored. When the data is in the buffer,
the database does not have to be accessed, because buffers
enable direct reads from the main memory of the application
server.
There are two advantages to this:
1> Accesses to SAP buffers are normally 10 to 100 times
faster than accesses to the database.
2> Database load is reduced. This is increasingly important
as your system grows in size.
Monitoring SAP Table Buffering
Three problems can occur in the area of SAP table buffering
and they Problem areas should be monitored:
1> Tables are designed too small and as a result,
displacements (swaps)occur. Check that the table buffer has
at least 10% free space and at least 20% free directory entries.
2> Tables may be buffered that, for reasons of performance,
should not have been buffered, either because they are
changed (invalidated) too often or because they are too large.
3> Tables that should be buffered for reasons of performance
are not buffered. This is mainly the case for tables that
are created in the customer system, whether explicitly in
the ABAP dictionary or implicitly in customizing (for
example, condition tables).
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to see when were the optimizer stats last time run?
Hi I am new in this forum and in this practice. can anyone help me out in finding out how to get training material for SAP CRM 2007.
What are the different modules of SAP?
What are steps for DB Refresh?
What is difference between oracle 9i and oracle 10g?
Explain kernel upgrade?
please share sap basis admin interview questions .. thanks sadik
What is the purpose of table tadir?
Where do you download trail version of sap ecc, what is sap cal?
Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.
How to assign a mass Tables in Auth Group by using T-code:se54
in oracle script @? "?" question mark means what it indicate?
How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?
How to add authorizations, how you will maintain profiles?
How client refresh is different than client copy?