SAP ABAP Table TST04SQD (SAP DB: Table for Database Summary)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN (Package) DBA: All the rest in English

Basic Data

Table Category	INTTAB	Structure
Structure	TST04SQD	Table Relationship Diagram
Short Description	SAP DB: Table for Database Summary

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
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	CACHESIZE	☐	CACHESIZE	CHAR14	CHAR	14	0	SAP MaxDB: Cache Size in KB
2	CACHEACC	☐	CACHEACC	CHAR26	CHAR	26	0	SAP MaxDB: Cache Accesses
3	CACHEHITS	☐	CACHEHITS	CHAR26	CHAR	26	0	SAP MaxDB: Cache Hits
4	HITRATE	☐	HITRATE	CHAR14	CHAR	14	0	SAP DB: Cache Hit Rate (%)
5	SQLCOMM	☐	SQLCOMM	CHAR26	CHAR	26	0	SAP DB: Number of SQL Commands
6	ROLLBACKS	☐	ROLL_BACKS	CHAR26	CHAR	26	0	SAP DB: Number of Rollbacks
7	COMMITS	☐	COMMITS_	CHAR26	CHAR	26	0	SAP MaxDB: Number of Commits
8	PREPARES	☐	PREPARES	CHAR26	CHAR	26	0	SAP DB: Number of Prepares
9	EXECUTES	☐	EXECUTES	CHAR26	CHAR	26	0	SAP DB: Number of Executes
10	CREATES	☐	CREATES	CHAR26	CHAR	26	0	SAP MaxDB: Number of Created DB Objects
11	ALTERS	☐	ALTERS	CHAR26	CHAR	26	0	SAP MaxDB: Number of Altered DB Objects
12	DROPS	☐	DROPS	CHAR26	CHAR	26	0	SAP DB: Number of Dropped DB objects
13	SHOWS	☐	SHOWS	CHAR26	CHAR	26	0	SAP MaxDB: Number of Shows
14	PHYREADS	☐	PHYREADS	CHAR26	CHAR	26	0	SAP DB: Number of Physical Reads
15	PHYWRITES	☐	PHYWRITES	CHAR26	CHAR	26	0	SAP DB: Number of Physical Writes
16	LOGREADS	☐	LOG_READS	CHAR26	CHAR	26	0	SAP MaxDB: Number of Logical Reads
17	LOGWRITES	☐	LOG_WRITES	CHAR26	CHAR	26	0	SAP MaxDB: Number of Logical Writes
18	LOCKENTRY	☐	LOCKENTRY	CHAR26	CHAR	26	0	SAP DB: Available Lock Entries
19	MAXENTRIES	☐	MAXENTRIES	CHAR26	CHAR	26	0	SAP MaxDB: Maximum Used Lock Entries
20	AVGENTRIES	☐	AVGENTRIES	CHAR26	CHAR	26	0	SAP DB: Average Used Lock Entries
21	ROWENTRIES	☐	ROWENTRIES	CHAR26	CHAR	26	0	SAP DB: Number of Current Row Locks
22	TABENTRIES	☐	TABENTRIES	CHAR26	CHAR	26	0	SAP MaxDB: Number of Current Table Locks
23	COLLISION	☐	COLLISION	CHAR26	CHAR	26	0	SAP MaxDB: Lock List Collisions Since Restart
24	ESCALATION	☐	ESCALATION	CHAR26	CHAR	26	0	SAP MaxDB: Lock List Escalations Since Restart
25	LOCKHOLDER	☐	LOCKHOLDER	CHAR26	CHAR	26	0	SAP DB: Number of Transactions Holding Locks
26	LOCKREQ	☐	LOCKREQ	CHAR26	CHAR	26	0	SAP DB: Number of Transactions Requesting Locks
27	LOGPAGES	☐	LOGPAGES	CHAR26	CHAR	26	0	SAP MaxDB: Log Pages Written
28	LOGWAITS	☐	LOGWAITS	CHAR26	CHAR	26	0	SAP MaxDB: Number of Wait Situations for Log Writer
29	GROUPCOM	☐	GROUPCOM	CHAR26	CHAR	26	0	SAP DB: Number of Group Commits
30	QUEUEOVER	☐	QUEUEOVER	CHAR26	CHAR	26	0	SAP DB: Log Queue Overflows
31	TABLESCANS	☐	TABLESCANS	CHAR26	CHAR	26	0	SAP DB: Number of Table Scans
32	INDEXSCANS	☐	INDEXSCANS	CHAR26	CHAR	26	0	SAP DB: Number of Index Scans
33	CACHESORTS	☐	CACHESORTS	CHAR26	CHAR	26	0	SAP MaxDB: Number of Sort Operations
34	ROWSORTS	☐	ROWSORTS	CHAR26	CHAR	26	0	SAP DB: Sorted Rows

History

Last changed by/on	SAP	20130604
SAP Release Created in