Precise Application Performance Platform 10.3.x

Page History

Versions Compared

Key

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

...

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)	`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_`

LOCALE_KEY

CLIENT The

locale ID on which the transaction took place

ID of the SAP client executing the step.

SPTS_

APP

WORK_

KEY

TYPE The

ID of application to which the transaction TCODE belongs

transaction's work type. For example: Dialog, Update, or Program.

SPTS_

ORG

LOCALE_KEY

The ID of the

user's organization executing this transaction

locale on which the transaction occurred.
`SPTS_APPSVR_KEY`	The ID of the application server where the transaction occurred.
`SPTS_URL_`

CLIENT

KEY The

key of the

SAP client executing the step.SPTS_WORK_TYPEThe transaction's work type. For example: Dialog, Update, or Program.

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

APP_TIME_SUM

Time

Total time spent

waiting

in the

dispatcher for a work process, in seconds.SPTS_APP_TIME_SUMTotal 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`

_GREEN_SUM

_RFC_SRV_DEST_COUNT_SUM For future use

Number of transactions that their SLA time does not exceed their Near Breach or Breach SLA thresholds

SPTS_

YELLOW

RFC_SRV_CALLS_COUNT_SUM

Number of transactions that their SLA time exceeds the Near Breach SLA threshold but not the Breach threshold

For future use.

SPTS

_RED

_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

OraclePRESExpression DescriptionSUM(SPTS_QUEUE

_TIME_SUM

	For future use.
`SPTS_`

APP

RFC_

TIME

SRV_

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.

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.

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 11

New Version 12

Key

Expressions

PW_SPTS_TRAN_STAT_

LS_T

Expressions

PW_SPTS_TRAN_STAT_OA_T

PW_SPTS_TRAN_STAT_OLSU_T