openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/GET_SQLPERFMEMORY_MSS:
    post:
      tags:
      - SFMSS_PERF
      summary: retrieve data from sap_perfdb on memory usage
      operationId: /rfc/GET_SQLPERFMEMORY_MSS
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CON_NAME:
                  type: string
                  default: DEFAULT
                  maxLength: 30
                  description: Logical name for a database connection
                SCHEMA:
                  type: string
                  default: ' '
                  maxLength: 128
                  description: Schema name
                MEMUSAGE:
                  type: array
                  items:
                    type: object
                    properties:
                      CONNECTMEM:
                        type: integer
                        format: int64
                        description: Amount of dynamic memory the server is using for connections
                      WRKPROCMEM:
                        type: integer
                        format: int64
                        description: Amount of memory granted to executing processes in KB
                      LOCKMEMORY:
                        type: integer
                        format: int64
                        description: Amount of dynamic memory used for locks in KB
                      MAXWSPMEM:
                        type: integer
                        format: int64
                        description: Maximum amount of memory available for executing SQL process
                      OPTQRYMEM:
                        type: integer
                        format: int64
                        description: Amount of memory SQL Server is using for query optimization
                      SQLCACMEM:
                        type: integer
                        format: int64
                        description: Amount of memory being used for dynamic SQL cache in KB
                      TARSRVMEM:
                        type: integer
                        format: int64
                        description: Amount of memory SQL Server is willing to consume in KB
                      TTLSRVMEM:
                        type: integer
                        format: int64
                        description: Amount of memory SQL Server is currently using in KB.
                      USERCONCTS:
                        type: integer
                        format: int64
                        description: Number of user connections to the SQL Server system
                      CACHEHIT:
                        type: integer
                        format: int64
                        description: Percentage of pages found in the buffer cache
                      DATACACHSZ:
                        type: integer
                        format: int64
                        description: Size in KB of the data cache, including unused space
                      CACHESIZE:
                        type: integer
                        format: int64
                        description: Size in KB of the procedure cache, including unused space.
                      BUFFCOMMIT:
                        type: integer
                        format: int64
                        description: Number of committed pages in cache.
                      FREEBUFFER:
                        type: integer
                        format: int64
                        description: Number of free pages available in cache.
                      STLPAGECNT:
                        type: integer
                        format: int64
                        description: Number of buffer pages taken for other memory requirements
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  MEMUSAGE:
                    type: array
                    items:
                      type: object
                      properties:
                        CONNECTMEM:
                          type: integer
                          format: int64
                          description: Amount of dynamic memory the server is using for connections
                        WRKPROCMEM:
                          type: integer
                          format: int64
                          description: Amount of memory granted to executing processes in KB
                        LOCKMEMORY:
                          type: integer
                          format: int64
                          description: Amount of dynamic memory used for locks in KB
                        MAXWSPMEM:
                          type: integer
                          format: int64
                          description: Maximum amount of memory available for executing SQL process
                        OPTQRYMEM:
                          type: integer
                          format: int64
                          description: Amount of memory SQL Server is using for query optimization
                        SQLCACMEM:
                          type: integer
                          format: int64
                          description: Amount of memory being used for dynamic SQL cache in KB
                        TARSRVMEM:
                          type: integer
                          format: int64
                          description: Amount of memory SQL Server is willing to consume in KB
                        TTLSRVMEM:
                          type: integer
                          format: int64
                          description: Amount of memory SQL Server is currently using in KB.
                        USERCONCTS:
                          type: integer
                          format: int64
                          description: Number of user connections to the SQL Server system
                        CACHEHIT:
                          type: integer
                          format: int64
                          description: Percentage of pages found in the buffer cache
                        DATACACHSZ:
                          type: integer
                          format: int64
                          description: Size in KB of the data cache, including unused space
                        CACHESIZE:
                          type: integer
                          format: int64
                          description: Size in KB of the procedure cache, including unused space.
                        BUFFCOMMIT:
                          type: integer
                          format: int64
                          description: Number of committed pages in cache.
                        FREEBUFFER:
                          type: integer
                          format: int64
                          description: Number of free pages available in cache.
                        STLPAGECNT:
                          type: integer
                          format: int64
                          description: Number of buffer pages taken for other memory requirements
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
