openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/SQL_MSSQL_MSSTATS_LIST:
    post:
      tags:
      - STUL
      summary: SQL Server get MSSTATS list for one server
      operationId: /rfc/SQL_MSSQL_MSSTATS_LIST
      requestBody:
        content:
          application/json:
            schema:
              properties:
                MSSTATS_LIST:
                  type: array
                  items:
                    type: object
                    properties:
                      SPNAME:
                        type: string
                        maxLength: 255
                        description: SQL Server stored procedure name
                      NCALL:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: number of calls'
                      TOTAL_MS:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: total runtime'
                      AVG_MS:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: average runtime'
                      MAX_MS:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: maximum runtime'
                      MIN_MS:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: minimum runtime'
                      RF_TOT_MS:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: total runtime w/ fetch'
                      RF_AVG_MS:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: average runtime w/ fetch'
                      RF_MAX_MS:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: max runtime w/ fetch'
                      RF_MIN_MS:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: minimum runtime w/fetch'
                      MIN_ROWS:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: minimum rows returned'
                      MAX_ROWS:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: maximum rows returned'
                      TOTAL_ROWS:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: total rows returned'
                      AVG_ROWS:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: average rows returned?'
                      PCURSOR:
                        type: string
                        maxLength: 1
                        description: 'SQL Server SP statistics MSSTATS: cursor usage'
                      ROW_COUNT:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: row count longest call'
                      RF_MS:
                        type: integer
                        format: int32
                        description: 'SQL Server SP statistics MSSTATS: total runtime longest call'
                STATUS_RECORD:
                  type: array
                  items:
                    type: object
                    properties:
                      COLLECTING:
                        type: string
                        maxLength: 1
                        description: SQL Server MSSTATS data
                      PNSIZE:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      PNUSED:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      PNREPL:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      TSPSIZE:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      TSPUSED:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      TSPUSEDPCT:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      TSPSTRTOT:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      TSPSTRUSED:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      TSPSTRUPCT:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      TSPBODIES:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      TSPBODYPCT:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      PSPARGS:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      PSPARGSPCT:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      TSPARGS:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      TSPARGSPCT:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
                      TSPREPL:
                        type: integer
                        format: int32
                        description: SQL Server MSSTATS data
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  LAST_RESET:
                    type: string
                    maxLength: 120
                    description: SQL Server DBCC output line
                  MSSTATS_LIST:
                    type: array
                    items:
                      type: object
                      properties:
                        SPNAME:
                          type: string
                          maxLength: 255
                          description: SQL Server stored procedure name
                        NCALL:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: number of calls'
                        TOTAL_MS:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: total runtime'
                        AVG_MS:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: average runtime'
                        MAX_MS:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: maximum runtime'
                        MIN_MS:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: minimum runtime'
                        RF_TOT_MS:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: total runtime w/ fetch'
                        RF_AVG_MS:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: average runtime w/ fetch'
                        RF_MAX_MS:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: max runtime w/ fetch'
                        RF_MIN_MS:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: minimum runtime w/fetch'
                        MIN_ROWS:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: minimum rows returned'
                        MAX_ROWS:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: maximum rows returned'
                        TOTAL_ROWS:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: total rows returned'
                        AVG_ROWS:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: average rows returned?'
                        PCURSOR:
                          type: string
                          maxLength: 1
                          description: 'SQL Server SP statistics MSSTATS: cursor usage'
                        ROW_COUNT:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: row count longest call'
                        RF_MS:
                          type: integer
                          format: int32
                          description: 'SQL Server SP statistics MSSTATS: total runtime longest call'
                  STATUS_RECORD:
                    type: array
                    items:
                      type: object
                      properties:
                        COLLECTING:
                          type: string
                          maxLength: 1
                          description: SQL Server MSSTATS data
                        PNSIZE:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        PNUSED:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        PNREPL:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        TSPSIZE:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        TSPUSED:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        TSPUSEDPCT:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        TSPSTRTOT:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        TSPSTRUSED:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        TSPSTRUPCT:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        TSPBODIES:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        TSPBODYPCT:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        PSPARGS:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        PSPARGSPCT:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        TSPARGS:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        TSPARGSPCT:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
                        TSPREPL:
                          type: integer
                          format: int32
                          description: SQL Server MSSTATS data
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
