Precise Application Performance Platform 10.3.x

Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

Host statistics table. Also has D, H, W, M, B, BT, BH, BD, BW, and BM summary levels.

Column Name	Column Description
`SPHS_PWII_INSTANCE_ID`	The instance ID.
`SPHS_TIMESTAMP`	The time of the host samples (aligned to 5 minutes).
`SPHS_RECEIVED_TIMESTAMP`	The received timestamp.
`SPHS_MINUTES_COUNT_SUM`	The minutes count.
`SPHS_PWHG_ID`	The hour group in the PW.
`SPHS_HOST_KEY`	The sampled host machine ID.
`SPHS_REC_COUNT_SUM`	Total number of samples made to the host in the specified time.
`SPHS_LOAD_AVG1_AVG`	The average number of work processes waiting for a free processor.
`SPHS_LOAD_AVG5_AVG`	The average number of work processes waiting for a free processor.
`SPHS_LOAD_AVG15_AVG`	The average number of work processes waiting for a free processor.
`SPHS_INTERRUPTS_AVG`	The average number of times per second the operating system had to interrupt system resources during process activity.
`SPHS_SYS_CALLS_AVG`	The average number of times the operating system performed system (privileged/root) calls per second.
`SPHS_CONTEXT_SW_AVG`	The average number of times the operating system had to switch CPU resources from one form of work to another per second.
`SPHS_USER_MODE_AVG`	The average CPU workload caused by user processes (SAP system or database); average percentage of the CPU that is used for user processes.
`SPHS_SYS_MODE_AVG`	The average CPU workload caused by operating system processes; average percentage of the CPU that is used for operating system processes.
`SPHS_IDLE_AVG`	The average percentage of the CPU that was not consumed.
`SPHS_PAGE_INS_AVG`	The average paging in rate per second.
`SPHS_PAGE_OUTS_AVG`	The average paging out rate per second.
`SPHS_KB_PAGE_INS_AVG`	The average paging in data amount (in KB) per second.
`SPHS_KB_PAGE_OUTS_AVG`	The average paging out data amount (in KB) per second.
`SPHS_PHYS_MEMORY_AVG`	The amount of physical operating system memory (in KB).
`SPHS_FREE_MEMORY_AVG`	The average amount of free memory (in KB).
`SPHS_SWAP_CONFIG_AVG`	The configured size of the swap area (in KB).
`SPHS_SWAP_FREE_AVG`	The average free swap space (in KB).
`SPHS_SWAP_SIZE_AVG`	The average allocated swap space (in KB).
`SPHS_SWAP_MAX`	The maximum swap space (in KB) that was allocated.

PW_SPDS_DETAILS_STAT_T

Step statistics table.

Column Name	Column Description
`SPDS_PWII_INSTANCE_ID`	The instance ID.
`SPDS_TIMESTAMP`	The start time of the step aligned to the time grain (5 minutes).
`SPDS_RECEIVED_TIMESTAMP`	The received timestamp.
`SPDS_MINUTES_COUNT_SUM`	The minutes count.
`SPDS_PWHG_ID`	The hour group in the PW.
`SPDS_LOCALE_KEY`	The ID of the locale, on which the step took place.
`SPDS_HOST_KEY`	The ID of the host machine, on which the step took place.
`SPDS_TCODE_KEY`	The step's TCODE ID.
`SPDS_TRAN_KEY`	The step's TCODE or Program ID.
`SPDS_PGM_KEY`	The ID of the executing ABAP program.
`SPDS_USER_KEY`	The ID of the user executing the step.
`SPDS_APP_KEY`	The ID of application the step's TCODE belongs to.
`SPDS_ORG_KEY`	The ID of the user's organization executing the step.
`SPDS_APPSVR_KEY`	The ID of the application server, on which the step occurred.
`SPDS_CLIENT`	The ID of the SAP client user that executed the step belongs to.
`SPDS_WORK_TYPE`	The step's work type. For example: Dialog, Update, Program.
`SPDS_TRAN_TYPE`	The step detailed type. For example: Login/Logout , Buffer synchronization, etc.
`SPDS_GUIPGM_NAME`	The GUI program the step executed.
`SPDS_DYNPRO`	The screen number.
`SPDS_STEP_COUNT_SUM`	Number of identical steps per time slice.
`SPDS_QUEUE_TIME_SUM`	Time spent waiting in the dispatcher for a work process (in seconds).
`SPDS_RFC_TIME_SUM`	Total time spent in remote function calls (in seconds).
`SPDS_STEP_TIMESTAMP`	The start time of the step.
`SPDS_TERMINAL_KEY`	The ID of the terminal which activated the step.
`SPDS_APP_TIME_SUM`	Total time spent in the application server (in seconds).
`SPDS_DB_TIME_SUM`	Total time spent in the database (in seconds).
`SPDS_LOAD_TIME_SUM`	Total time spent on loading from the database and generate objects like ABAP source code, CUA, and screen information.
`SPDS_ENQ_TIME_SUM`	Time spent waiting for a resource protected by a SAP lock (in seconds).
`SPDS_CPU_TIME_SUM`	CPU time consumed by the work processes (in seconds).
`SPDS_ROLLWAIT_TIME_SUM`	Time spent in a rolled out status in the application server (in seconds).
`SPDS_GUI_TIME_SUM`	The GUI time (in seconds) (available from SAP version 4.6).
`SPDS_FENET_TIME_SUM`	The FE Net time (in seconds) (available from SAP version 4.6).
`SPDS_ROUNDTRIPS_SUM`	Number of round-trips performed (available from SAP version 4.6).
`SPDS_PRIVMODE_COUNT_SUM`	Number of times a work process ran in private mode.
`SPDS_MEMORY_USED_SUM`	Amount of SAP’s extended (shared) memory attributed to the application.
`SPDS_KB_TRANSFERRED_SUM`	Amount of database data transferred (in KB).
`SPDS_INPUTBYTES_SUM`	Total number of bytes transferred from the front end to the application server.
`SPDS_OUTPUTBYTES_SUM`	Total number of bytes transferred from the application server to the front end.
`SPDS_PHY_READ_COUNT_SUM`	Volume of read requests transferred to the database server.
`SPDS_DB_SEQ_REQS_SUM`	Number of requests for a database sequential read.
`SPDS_DB_SEQ_CALL_SUM`	Number of actual calls to the database to satisfy a sequential read request.
`SPDS_DB_SEQ_TIME_SUM`	Time spent in the database for sequential reads (in seconds).
`SPDS_DB_DIR_REQS_SUM`	Number of requests for database direct read.
`SPDS_DB_DIR_CALL_SUM`	Number of actual calls to the database to satisfy a direct read request.
`SPDS_DB_DIR_TIME_SUM`	Time spent in the database for direct reads (in seconds).
`SPDS_DB_ROWS_READ_SUM`	Number of rows read from the database.
`SPDS_DB_READ_REQS_SUM`	Total number of database read requests.
`SPDS_DB_REQS_SUM`	Total number of database requests.
`SPDS_RFC_SRV_DEST_COUNT_SUM`	For future use.
`SPDS_RFC_SRV_CALLS_COUNT_SUM`	For future use.
`SPDS_RFC_SRV_CALL_TIME_SUM`	For future use.
`SPDS_RFC_SRV_EXE_TIME_SUM`	For future use.
`SPDS_RFC_SRV_DATA_SENT_SUM`	For future use.
`SPDS_RFC_SRV_DATA_RCV_SUM`	For future use.
`SPDS_RFC_CLNT_DEST_COUNT_SUM`	For future use.
`SPDS_RFC_CLNT_CALLS_COUNT_SUM`	For future use.
`SPDS_RFC_CLNT_CALL_TIME_SUM`	For future use.
`SPDS_RFC_CLNT_EXE_TIME_SUM`	For future use.
`SPDS_RFC_CLNT_CLNT_DATA_SENT`	For future use.
`SPDS_RFC_CLNT_CLNT_DATA_RCV_SUM`	For future use.

Expressions

Oracle	PRES	Expression Description
`SUM(SPDS_QUEUE_TIME_SUM+SPDS_APP_TIME_SUM+ SPDS_DB_TIME_SUM+SPDS_FENET_TIME_SUM+SPDS_GUI_TIME_SUM)`	`SUM(SPDS_QUEUE_TIME_SUM+SPDS_APP_TIME_SUM+ SPDS_DB_TIME_SUM+SPDS_FENET_TIME_SUM+SPDS_GUI_TIME_SUM)`	The sum of all the response time components of the step.
`SUM(SPDS_QUEUE_TIME_SUM+SPDS_APP_TIME_SUM+ SPDS_DB_TIME_SUM+SPDS_FENET_TIME_SUM+SPDS_ GUI_TIME_SUM)/SUM(SPDS_STEP_COUNT_SUM)`	`SUM(SPDS_QUEUE_TIME_SUM+SPDS_APP_TIME_SUM+ SPDS_DB_TIME_SUM+SPDS_FENET_TIME_SUM+SPDS_ GUI_TIME_SUM)/SUM(SPDS_STEP_COUNT_SUM)`	The average of all the response time components of the step.
`SUM(SPDS_GUI_TIME_SUM+SPDS_FENET_TIME_SUM)`	`SUM(SPDS_GUI_TIME_SUM+SPDS_FENET_TIME_SUM)`	The sum of the client time components of the step.
`SUM(SPDS_GUI_TIME_SUM+SPDS_FENET_TIME_SUM)/ SUM(SPDS_STEP_COUNT_SUM)`	`SUM(SPDS_GUI_TIME_SUM+SPDS_FENET_TIME_SUM)/ SUM(SPDS_STEP_COUNT_SUM)`	The average of the client time components of the step.

PW_SPTS_TRAN_STAT_T

Transaction Statistics table. Also has D, H, W, M, B, BT, BH, BD, BW, and BM 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 (5 minutes).
`SPTS_RECEIVED_TIMESTAMP`	The received timestamp.
`SPTS_MINUTES_COUNT_SUM`	The minutes count.
`SPTS_PWGH_ID`	The hour group in the PW.
`SPTS_LOCALE_KEY`	The locale ID, on which the transaction took place.
`SPTS_HOST_KEY`	ID of the host machine, on which the transaction took place.
`SPTS_TRAN_KEY`	The ID of the transaction (Program or TCODE).
`SPTS_USER_KEY`	The ID of the user executing the transaction.
`SPTS_APP_KEY`	The ID of application to which the transaction's TCODE belongs.
`SPTS_ORG_KEY`	The ID of the user's organization executing the transaction.
`SPTS_APPSVR_KEY`	The ID of the application server, on which 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_TERMINAL_KEY`	The ID of the terminal which activated the transaction.
`SPTS_URL_KEY`	The key of the URL that activated the transaction.
`SPTS_TRAN_TYPE`	The transaction's detailed type. For example: Login/Logout , Buffer synchronization, etc.
`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_ENG_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 version 4.6).
`SPTS_FENET_TIME_SUM`	The FE Net time (in seconds) (available from SAP version 4.6).
`SPTS_ROUNDTRIPS_SUM`	Number of round-trips performed (available from SAP version 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 (could not 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
`SSUM(SPTS_QUEUE_TIME_SUM+SPTS_APP_TIME_SUM+ SPTS_DB_TIME_SUM+SPTS_FENET_TIME_SUM+SPTS_GUI_TIME_SUM)`	`SSUM(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_AOLS_T

Aggregated Transaction Statistics table. Group by: Instance ID, Timestamp, Hour group, Client, Work type, Locale, Appsvr, Organization, or Application. 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_LOCALE_KEY`	The locale ID, on which the transaction took place.
`SPTS_APP_KEY`	The application ID to which the transaction's TCODE belongs.
`SPTS_ORG_KEY`	The ID of the user's organization executing the transaction.
`SPTS_APPSVR_KEY`	The ID of the application server where the transaction occurred.
`SPTS_CLIENT`	The ID of the SAP's 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 version 4.6).
`SPTS_FENET_TIME_SUM`	The FE Net time (in seconds) (available from SAP version 4.6).
`SPTS_ROUNDTRIPS_SUM`	Number of round-trips performed (available from SAP version 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 (could not 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_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)`	`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.

Scroll Ignore

scroll-pdf	true
scroll-office	true
scroll-chm	true
scroll-docbook	true
scroll-eclipsehelp	true
scroll-epub	true
scroll-html	true

Newtabfooter
alias IDERA
url http://www.idera.com
|
Newtabfooter
alias Products
url https://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
alias Purchase
url https://www.idera.com/buynow/onlinestore
|
Newtabfooter
alias Support
url https://idera.secure.force.com/precise/
|
Newtabfooter
alias Community
url http://community.idera.com
|
Newtabfooter
alias Resources
url http://www.idera.com/resourcecentral
|
Newtabfooter
alias About Us
url http://www.idera.com/about/aboutus
|
Newtabfooter
alias Legal
url https://www.idera.com/legal/termsofuse

Content

Space Tools

Versions Compared

Old Version 6

New Version 7

Key

PW_SPDS_DETAILS_STAT_T

Expressions

PW_SPTS_TRAN_STAT_T

Expressions

PW_SPTS_TRAN_STAT_AOLS_T

Expressions