Page History
...
Column Name | Column Description |
---|---|
SPTS_PWII_INSTANCE_ID | The instance ID. |
SPTS_TIMESTAMP | The end time of the transaction aligned to the time grain of the table (hour, day, etc.). |
SPTS_RECEIVED_TIMESTAMP | The received timestamp. |
SPTS_MINUTES_COUNT_SUM | The minutes count. |
SPTS_PWHG_ID | The hour group in the PW. |
SPTS_TRAN_KEY | The transaction ID (TCODE or Program). |
SPTS_APP_KEY | The ID of application to which the transaction TCODE belongs. |
SPTS_APPSVR_KEY | The ID of the application server where the transaction occurred. |
SPTS_CLIENT | The ID of the SAP client executing the step. |
SPTS_WORK_TYPE | The transaction's work type. For example: Dialog, Update, or Program. |
SPTS_STEP_COUNT_SUM | Number of steps per transaction. |
SPTS_TRAN_COUNT_SUM | Number of identical transactions per time slice. |
SPTS_RFC_TIME_SUM | Total time spent in the remote function calls, in seconds. |
SPTS_QUEUE_TIME_SUM | Time spent waiting in the dispatcher for a work process, in seconds. |
SPTS_APP_TIME_SUM | Total time spent in the application server, in seconds. |
SPTS_DB_TIME_SUM | Total time spent in the database, in seconds. |
SPTS_LOAD_TIME_SUM | Total time spent on loading from the database and generate objects like ABAP source code, CUA, and screen information. |
SPTS_ENQ_TIME_SUM | Time spent waiting for a resource protected by a SAP lock, in seconds. |
SPTS_CPU_TIME_SUM | CPU time consumed by the work processes, in seconds. |
SPTS_ROLLWAIT_TIME_SUM | Time spent in a rolled out status in the application server, in seconds. |
SPTS_GUI_TIME_SUM | The GUI time, in seconds. Available from SAP 4.6. |
SPTS_FENET_TIME_SUM | The FE Net time, in seconds. Available from SAP 4.6. |
SPTS_ROUNDTRIPS_SUM | Number of round-trips performed. Available from SAP 4.6. |
SPTS_PRIVMODE_COUNT_SUM | Number of times a work process ran in private mode. |
SPTS_MEMORY_USED_SUM | Amount of SAP’s extended (shared) memory attributed to the application. |
SPTS_KB_TRANSFERRED_SUM | Amount of database data transferred (in KB). |
SPTS_INPUTBYTES_SUM | Total number of bytes transferred from the front end to the application server. |
SPTS_OUTPUTBYTES_SUM | Total number of bytes transferred from the application server to the front end. |
SPTS_PHY_READ_COUNT_SUM | Number of read access performed to the database. Cannot be satisfied from SAP buffers. |
SPTS_DB_SEQ_REQS_SUM | Number of requests for database sequential read. |
SPTS_DB_SEQ_CALL_SUM | Number of actual calls to the database to satisfy a sequential read request. |
SPTS_DB_SEQ_TIME_SUM | Time spent in the database for sequential reads, in seconds. |
SPTS_DB_DIR_REQS_SUM | Number of requests for database direct read. |
SPTS_DB_DIR_CALL_SUM | Number of actual calls to the database to satisfy a direct read request. |
SPTS_DB_DIR_TIME_SUM | Time spent in the database for direct reads, in seconds. |
SPTS_DB_ROWS_READ_SUM | Number of rows read from the database. |
SPTS_DB_READ_REQS_SUM | Total number of database read requests. |
SPTS_DB_REQS_SUM | Total number of database requests. |
SPTS_START_BIT_MAP | Insight SmarTune bitmap. |
SPTS_GREEN_SUM | Number of transactions that their SLA time does not exceed their Near Breach or Breach SLA thresholds. |
SPTS_YELLOW_SUM | Number of transactions that their SLA time exceeds the Near Breach SLA threshold but not the Breach threshold. |
SPTS_RED_SUM | Number of transactions that their SLA time exceeds the Breach SLA threshold. |
Expressions
Oracle | PRES | Expression Description |
---|---|---|
| SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+SPTS_DB_TIME_SUM+ SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM) | The sum of all the response time components of the step. |
SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+SPTS_DB_TIME_SUM+ SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+SPTS_DB_TIME_SUM+ SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | The average of all the response time components of the step. |
SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM) | SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM) | The sum of the client time components of the step. |
SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM) | The average of the client time components of the step. |
PW_SPTS_TRAN_STAT_
...
LS_T
Aggregated Transaction Statistics table. Group by: Instance ID, Timestamp, Hour group, Client, Work type, Locale, Appsvr, Organization, or ApplicationURL. Also has D, H, W, and M summary levels.
Column Name | Column Description |
---|---|
SPTS_PWII_INSTANCE_ID | The instance ID. |
SPTS_TIMESTAMP | The end time of the transaction aligned to the time grain of the table (hour, day, etc.). |
SPTS_RECEIVED_TIMESTAMP | The received timestamp. |
SPTS_MINUTES_COUNT_SUM | The minutes count. |
SPTS_PWHG_ID | The hour group in the PW. |
SPTS_ |
CLIENT | The |
ID of the SAP client executing the step. |
SPTS_ |
WORK_ |
TYPE | The |
transaction's work type. For example: Dialog, Update, or Program. |
SPTS_ |
LOCALE_KEY | The ID of the |
locale on which the transaction occurred. | |
SPTS_APPSVR_KEY | The ID of the application server where the transaction occurred. |
SPTS_URL_ |
KEY | The |
key of the |
SPTS_WORK_TYPE
URL that activated the transaction. | |
SPTS_STEP_COUNT_SUM | Number of steps per transaction. |
SPTS_TRAN_COUNT_SUM | Number of identical transactions per time slice. |
SPTS_RFC_TIME_SUM | Total time spent in the remote function calls, in seconds. |
SPTS_ |
APP_TIME_SUM |
Total time spent |
in the |
SPTS_APP_TIME_SUM
application server, in seconds. | |
SPTS_DB_TIME_SUM | Total time spent in the database, in seconds. |
SPTS_LOAD_TIME_SUM | Total time spent on loading from the database and generate objects like ABAP source code, CUA, and screen information. |
SPTS_ENQ_TIME_SUM | Time spent waiting for a resource protected by a SAP lock, in seconds. |
SPTS_CPU_TIME_SUM | CPU time consumed by the work processes, in seconds. |
SPTS_ROLLWAIT_TIME_SUM | Time spent in a rolled out status in the application server, in seconds. |
SPTS_GUI_TIME_SUM | The GUI time, in seconds. Available from SAP 4.6. |
SPTS_FENET_TIME_SUM | The FE Net time, in seconds. Available from SAP 4.6. |
SPTS_ROUNDTRIPS_SUM | Number of round-trips performed. Available from SAP 4.6. |
SPTS_PRIVMODE_COUNT_SUM | Number of times a work process ran in private mode. |
SPTS_MEMORY_USED_SUM | Amount of SAP’s extended (shared) memory attributed to the application. |
SPTS_KB_TRANSFERRED_SUM | Amount of database data transferred (in KB). |
SPTS_INPUTBYTES_SUM | Total number of bytes transferred from the front end to the application server. |
SPTS_OUTPUTBYTES_SUM | Total number of bytes transferred from the application server to the front end. |
SPTS_PHY_READ_COUNT_SUM | Number of read access performed to the database. Cannot be satisfied from SAP buffers. |
SPTS_DB_SEQ_REQS_SUM | Number of requests for database sequential read. |
SPTS_DB_SEQ_CALL_SUM | Number of actual calls to the database to satisfy a sequential read request. |
SPTS_DB_SEQ_TIME_SUM | Time spent in the database for sequential reads, in seconds. |
SPTS_DB_DIR_REQS_SUM | Number of requests for database direct read. |
SPTS_DB_DIR_CALL_SUM | Number of actual calls to the database to satisfy a direct read request. |
SPTS_DB_DIR_TIME_SUM | Time spent in the database for direct reads, in seconds. |
SPTS_DB_ROWS_READ_SUM | Number of rows read from the database. |
SPTS_DB_READ_REQS_SUM | Total number of database read requests. |
SPTS_DB_REQS_SUM | Total number of database requests. |
SPTS |
_RFC_SRV_DEST_COUNT_SUM | For future use |
. |
SPTS_ |
RFC_SRV_CALLS_COUNT_SUM |
For future use. |
SPTS |
_RFC_SRV_CALL_TIME_SUM |
Number of transactions that their SLA time exceeds the Breach SLA threshold.
Expressions
For future use. |
SPTS_RFC_SRV_EXE |
_TIME_SUM |
For future use. | |
SPTS_ |
RFC_ |
SRV_ |
SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+SPTS_DB_TIME_SUM+ SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM)
SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+SPTS_DB_TIME_SUM+ SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM)
SUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+SPTS_DB_TIME_SUM+ SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM)
SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)
SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)
SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM)
SUM(SPTS_GUI_TIME_SUM+SPTS_FENET_TIME_SUM)/SUM(SPTS_STEP_COUNT_SUM)
PW_SPTS_TRAN_STAT_OA_T
...
DATA_SENT_SUM | For future use. |
SPTS_RFC_SRV_DATA_RCV_SUM | For future use. |
SPTS_RFC_CLNT_DESCT_COUNT_SUM | For future use. |
SPTS_RFC_CLNT_CALLS_COUNT_SUM | For future use. |
SPTS_RFC_CLNT_CALL_TIME_SUM | For future use. |
SPTS_RFC_CLNT_EXE_TIME_SUM | For future use. |
SPTS_RFC_CLNT_DATA_SENT_SUM | For future use. |
SPTS_RFC_CLNT_DATA_RCV_SUM | For future use. |
SPTS_GREEN_SUM | Number of transactions that their SLA time does not exceed their Near Breach or Breach SLA thresholds. |
SPTS_YELLOW_SUM | Number of transactions that their SLA time exceeds the Near Breach SLA threshold but not the Breach threshold. |
SPTS_RED_SUM | Number of transactions that their SLA time exceeds the Breach SLA threshold. |
PW_SPTS_TRAN_STAT_OLSU_T
Aggregated Transaction Statistics table. Group by: Instance ID, Timestamp, Hour group, Client, Work type, User, Terminal, Locale,, Appserver, Organization, or URL. Also has D, H, W, and M summary levels.
Column Name | Column Description |
---|---|
SPTS_PWII_INSTANCE_ID | The instance ID. |
SPTS_TIMESTAMP | The end time of the transaction aligned to the time grain of the table (hour, day, etc.). |
SPTS_RECEIVED_TIMESTAMP | The received timestamp. |
SPTS_MINUTES_COUNT_SUM | The minutes count. |
SPTS_PWHG_ID | The hour group in the PW. |
SPTS_CLIENT | The ID of the SAP client executing the step. |
SPTS_WORK_TYPE | The transaction's work type. For example: Dialog, Update, or Program. |
SPTS_LOCALE_KEY | The ID of the locale on which the transaction occurred. |
SPTS_USER_KEY | The ID of the user executing the transaction. |
SPTS_TERMINAL_KEY | The ID of the terminal executing the transaction. |
SPTS_APPSVR_KEY | The ID of the application server where the transaction occurred. |
SPTS_ORG_KEY | The ID of the user's organization executing the step. |
SPTS_URL_KEY | The key of the URL that activated the transaction. |
SPTS_STEP_COUNT_SUM | Number of steps per transaction. |
SPTS_TRAN_COUNT_SUM | Number of identical transactions per time slice. |
SPTS_RFC_TIME_SUM | Total time spent in the remote function calls, in seconds. |
SPTS_QUEUE_TIME_SUM | Time spent waiting in the dispatcher for a work process, in seconds. |
SPTS_APP_TIME_SUM | Total time spent in the application server, in seconds. |
SPTS_DB_TIME_SUM | Total time spent in the database, in seconds. |
SPTS_LOAD_TIME_SUM | Total time spent on loading from the database and generate objects like ABAP source code, CUA, and screen information. |
SPTS_ENQ_TIME_SUM | Time spent waiting for a resource protected by a SAP lock, in seconds. |
SPTS_CPU_TIME_SUM | CPU time consumed by the work processes, in seconds. |
SPTS_ROLLWAIT_TIME_SUM | Time spent in a rolled out status in the application server, in seconds. |
SPTS_GUI_TIME_SUM | The GUI time, in seconds. Available from SAP 4.6. |
SPTS_FENET_TIME_SUM | The FE Net time, in seconds. Available from SAP 4.6. |
SPTS_ROUNDTRIPS_SUM | Number of round-trips performed. Available from SAP 4.6. |
SPTS_PRIVMODE_COUNT_SUM | Number of times a work process ran in private mode. |
SPTS_MEMORY_USED_SUM | Amount of SAP’s extended (shared) memory attributed to the application. |
SPTS_KB_TRANSFERRED_SUM | Amount of database data transferred (in KB). |
SPTS_INPUTBYTES_SUM | Total number of bytes transferred from the front end to the application server. |
SPTS_OUTPUTBYTES_SUM | Total number of bytes transferred from the application server to the front end. |
SPTS_PHY_READ_COUNT_SUM | Number of read access performed to the database. Cannot be satisfied from SAP buffers. |
SPTS_DB_SEQ_REQS_SUM | Number of requests for database sequential read. |
SPTS_DB_SEQ_CALL_SUM | Number of actual calls to the database to satisfy a sequential read request. |
SPTS_DB_SEQ_TIME_SUM | Time spent in the database for sequential reads, in seconds. |
SPTS_DB_DIR_REQS_SUM | Number of requests for database direct read. |
SPTS_DB_DIR_CALL_SUM | Number of actual calls to the database to satisfy a direct read request. |
SPTS_DB_DIR_TIME_SUM | Time spent in the database for direct reads, in seconds. |
SPTS_DB_ROWS_READ_SUM | Number of rows read from the database. |
SPTS_DB_READ_REQS_SUM | Total number of database read requests. |
SPTS_DB_REQS_SUM | Total number of database requests. |
SPTS_RFC_SRV_DEST_COUNT_SUM | For future use. |
SPTS_RFC_SRV_CALLS_COUNT_SUM | For future use. |
SPTS_RFC_SRV_CALL_TIME_SUM | For future use. |
SPTS_RFC_SRV_EXE_TIME_SUM | For future use. |
SPTS_RFC_SRV_DATA_SENT_SUM | For future use. |
SPTS_RFC_SRV_DATA_RCV_SUM | For future use. |
SPTS_RFC_CLNT_DEST_COUNT_SUM | For future use. |
SPTS_RFC_CLNT_CALLS_ COUNT_SUM | For future use. |
SPTS_RFC_CLNT_CALL_TIME_SUM | For future use. |
SPTS_RFC_CLNT_EXE_TIME_SUM | For future use. |
SPTS_RFC_CLNT_DATA_SENT_SUM | For future use. |
SPTS_RFC_CLNT_DATA_RCV_SUM | For future use. |
SPTS_GREEN_SUM | Number of transactions that their SLA time does not exceed their Near Breach or Breach SLA thresholds. |
SPTS_YELLOW_SUM | Number of transactions that their SLA time exceeds the Near Breach SLA threshold but not the Breach threshold. |
SPTS_RED_SUM | Number of transactions that their SLA time exceeds the Breach SLA threshold. |