Programme SAP RSSQD003 - SAP DB: Buffer Statistics

Description
Online program
This program generates detailed statistics for accesses to the SQL-DBbuffer (caches). All values are calculated since the last DB restart.

Precondition
Call transaction ST04
Menu: Goto -> Activity -> Current statistics -> Cache statistics

Output

  • Accesses:

  • Total number of accesses
    • Successful:

    • Number of successful accesses
      • Failed:

      • Number of failed accesses
        • Hit Rate %:

        • Hit rate in %
          The individual buffers have the following functions:
          • Data:

          • Data buffer
            • File Directory:

            • Buffer for file handling
              • ISM:

              • Buffer for incremental store management
                • PSM:

                • Buffer for page store management
                  • USM:

                  • Buffer for user store management
                    • Log:

                    • Buffer for the log area
                      • Catalog:

                      • Catalog buffer
                        • Temporary:

                        • Session-specific buffer