SAP ABAP Table STRACSUR_D (DB Structure: Cumulated Performance Data from Trace and Stat)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-TWB-TST-P-GPA (Application Component) Global Performance Analysis (Transaction ST30)
     ⤷ S_PERF_TRA (Package) New Performance Trace / Statistics with DB Connection

Basic Data

Table Category	INTTAB	Structure
Structure	STRACSUR_D	Table Relationship Diagram
Short Description	DB Structure: Cumulated Performance Data from Trace and Stat

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	TOTALEXEC	☐	TOTALEXEC	DECI10	DEC	10	0	Total Number of Executions of Identical SQL Statements
2	EXECTIME	☐	EXECTIME	DEC12	DEC	12	0	Total Runtime for SQL Statements (in Microseconds)
3	RECPROCNUM	☐	RECPROCNUM	DECI10	DEC	10	0	Total Number of Database Records Passed to Program
4	WPROCTIME	☐	WPROCTIME		DEC	18	2	Time in Work Process (Reponse Time - Wait Time) in ms
5	KBYTETRANS	☐	KBYTETRANS		DEC	13	2	Amount of Data Transferred in KB (= Queue + Source + DSQL)
6	RESPTIME	☐	RESPTIME		DEC	18	2	Response Time in ms
7	WAITTIME	☐	WAITTIME1		DEC	13	2	Queue Wait Time in ms
8	CPUTIME	☐	CPUTIME		DEC	18	2	CPU Time in ms
9	LDGENTIME	☐	LDGENTIME		DEC	13	2	Load and Generation Time in ms
10	MEMORYUSED	☐	MEMORYUSED		DEC	13	2	Memory Used in MBytes
11	DBTIME	☐	DBTIME		DEC	13	2	Database Time in ms
12	DBCHANGES	☐	DBCHANGES		DEC	13	2	Number of Physical Database Changes
13	ROUNDTRIPS	☐	ROUNDTRIPS		DEC	18	2	SAP Workload: Number of Roundtrips
14	INOUTDATA	☐	INOUTDATA		DEC	16	2	Total Data Volume Between Front End and App. Server (KB)
15	INDATA	☐	INDATA_P		DEC	16	2	Average Data Volume to Application Server per Step (kBytes)
16	OUTDATA	☐	OUTDATA_P		DEC	16	2	Average Data Volume to Front End per Step (kBytes)
17	TOTALEX_ST	☐	TOTALEX_ST		DEC	13	2	Number of Database Accesses (SEL, UPD, INS, DEL)(Statistics)
18	RECPROCNUM_ST	☐	RECPROCNUM_ST		DEC	13	2	Total Number of DB Recs Delivered to Program (Statistics)
19	TOTALEXEC_SAW	☐	TOTALEXEC_SAW		DEC	13	2	Standard Deviation: Total Number of Identical SQL Statements
20	EXECTIME_SAW	☐	EXECTIME_SAW		DEC	15	2	Standard Deviation: Total Execution Time: SQL Statements
21	RECPROCNUM_SAW	☐	RECPROCNUM_SAW		DEC	13	2	Standard Deviation: Total Number of Database Recs Delivered
22	WPROCTIME_SAW	☐	WPROCTIME_SAW		DEC	18	2	Standard Deviation: Time in Work Process
23	KBYTETRANS_SAW	☐	KBYTETRANS_SAW		DEC	13	2	Standard Deviation: Transferred Data Volume in Kilobytes
24	RESPTIME_SAW	☐	RESPTIME_SAW		DEC	18	2	Standard Deviation: Response Time
25	WAITTIME_SAW	☐	WAITTIME_SAW		DEC	13	2	Standard Deviation: Wait Time in the Queue in ms
26	CPUTIME_SAW	☐	CPUTIME_SAW		DEC	18	2	Standard Deviation: CPU Time
27	LDGENTIME_SAW	☐	LDGENTIME_SAW		DEC	13	2	Standard Deviation: Load and Generation Time in ms
28	MEMORYUSED_SAW	☐	MEMORYUSED_SAW		DEC	13	2	Standard Deviation: Size of Utilized Memory
29	DBTIME_SAW	☐	DBTIME_SAW		DEC	13	2	Standard Deviation: Database Time in ms
30	DBCHANGES_SAW	☐	DBCHANGES_SAW		DEC	13	2	Standard Deviation: Number of Physical Database Changes
31	ROUNDTRIPS_SAW	☐	ROUNDTRIPS_SAW		DEC	18	2	Standard Deviation: Number of Roundtrips
32	INDATA_SAW	☐	INDATA_SAW		DEC	16	2	Standard Deviation: Data Volume to Application Server
33	OUTDATA_SAW	☐	OUTDATA_SAW		DEC	16	2	Standard Deviation: Data Volume to Front End
34	TOTALEX_ST_SAW	☐	TOTALEX_ST_SAW		DEC	13	2	Standard Deviation: Number of DB Accesses (Statistics)
35	RECPROCNUM_STSAW	☐	RECPROCNUM_ST_SAW		DEC	13	2	Standard Deviation: Number of DB Recs Delivered (Statistics)
36	STEXTKEY	☐	STEXTKEY		CHAR	4	0	Metatext

History

Last changed by/on	SAP	20110908
SAP Release Created in	610