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
What is difference between oracle 9i and oracle 10g?
Have you done any up gradations?
does the Tcode EWZ5 exist in ECC6?I'm using NW2004S SR2 abap engine and EWZ5 doesn't exist in that.so in that case what is the alternative to EWZ5?to see the list of users present in a client but not necessarily logged in and to to lock or unlock them? Thanks.
what are the pros and cons of auto extend of table spaces?
If you have a long-running Job, how do you analyse?
Where will u find transport error logs?
What is the difference between kernel replacement and support package?
Explain the system log?
How to set predecessor relationship between two transport requests?
How you will get help from OSS notes?
How will go about doing a client copy ?
what can we do if shadow instance is down and getting up in prepare phase of upgrade
what is the use of tcode SUSHARE in SAP and how the mass user authorizations compared?
How can you find a list of objects that have been repaired in the system?
How do you check the users logs in your system and how many sessions each user is generating?