openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/GET_SQLPERFACCESS_MSS:
    post:
      tags:
      - SFMSS_PERF
      summary: 'Retrieve data from the counter objects: ACCESS, BUFFER, and SQL Statistics'
      operationId: /rfc/GET_SQLPERFACCESS_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
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  ACCESSMTHS:
                    type: object
                    properties:
                      FULLSCANS:
                        type: integer
                        format: int64
                        description: Number of unrestricted base table or index scans
                      INDEXSRCH:
                        type: integer
                        format: int64
                        description: Number of index searches
                      EXTALLOCS:
                        type: integer
                        format: int64
                        description: Number of extents allocated to database objects
                      EXTDEALLS:
                        type: integer
                        format: int64
                        description: Number of extents deallocated in a database
                      PAGEALLOCS:
                        type: integer
                        format: int64
                        description: Number of pages allocated to database objects
                      PAGEDEALLS:
                        type: integer
                        format: int64
                        description: Number of pages deallocated in a database
                      PAGESPLITS:
                        type: integer
                        format: int64
                        description: Number of index page splits in a database
                      PROBESCANS:
                        type: integer
                        format: int64
                        description: Number of probe scans in a database
                      RANGESCANS:
                        type: integer
                        format: int64
                        description: Number of range scans through indexes
                      WORKFILES:
                        type: integer
                        format: int64
                        description: Number of work files created
                      WORKTABLES:
                        type: integer
                        format: int64
                        description: Number of work tables created
                      LAZYWRITES:
                        type: integer
                        format: int64
                        description: Number of pages written by the lazy writer to disk.
                      PAGEREADS:
                        type: integer
                        format: int64
                        description: Number of physical page reads
                      PAGEWRITES:
                        type: integer
                        format: int64
                        description: Number of physical page writes
                      REQBUFFPG:
                        type: integer
                        format: int64
                        description: Number of requests to find a page in the buffer pool.
                      READAHEAD:
                        type: integer
                        format: int64
                        description: Number of pages read in anticipation of use.
                      AUTOPARAM:
                        type: integer
                        format: int64
                        description: Number of auto-parameterization attempts
                      SQLBATCHS:
                        type: integer
                        format: int64
                        description: Number of SQL batch requests received by server.
                      SQLCOMPILE:
                        type: integer
                        format: int64
                        description: Number of SQL compilations
                      AVGLTCHWT:
                        type: integer
                        format: int64
                        description: Average wait time in ms for latch requests that waited.
                      LATCHWAITS:
                        type: integer
                        format: int64
                        description: Number of latch requests that had to wait before granted.
                  PERSEC:
                    type: object
                    properties:
                      FULLSCANS:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      INDEXSRCH:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      EXTALLOCS:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      EXTDEALLS:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      PAGEALLOCS:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      PAGEDEALLS:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      PAGESPLITS:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      PROBESCANS:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      RANGESCANS:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      WORKFILES:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      WORKTABLES:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      LAZYWRITES:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      PAGEREADS:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      PAGEWRITES:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      REQBUFFPG:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      READAHEAD:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      AUTOPARAM:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      SQLBATCHS:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      SQLCOMPILE:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      AVGLTCHWT:
                        type: number
                        description: Per second SQL Server performance counter (or %).
                      LATCHWAITS:
                        type: number
                        description: Per second SQL Server performance counter (or %).
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
