SAP ABAP Table SYBMON_ASEINSTANCE (SYB: ASE instance level performance)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	SYBMON_ASEINSTANCE	Table Relationship Diagram
Short Description	SYB: ASE instance level performance

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	INSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
2	ASE_VERSION	☐	DB6DBREL		CHAR	10	0	DB6: Database Release Level
3	NUMDEADLOCKS	☐			INT4	10	0
4	CONNECTIONS	☐			INT4	10	0
5	TRANSACTIONS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
6	LOCKSHELD	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
7	PROCESSMEMUSAGEKB	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
8	NET_PACKETSSENT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
9	NET_PACKETSRECEIVED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
10	NET_MB_SENT	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
11	NET_MB_RECEIVED	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
12	ROLLBACKS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
13	SELECTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
14	UPDATES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
15	INSERTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
16	DELETES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
17	MERGES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
18	UDIM_TOTAL	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
19	TABLEACCESSES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
20	INDEXACCESSES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
21	TEMPDBOBJECTS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
22	WORKTABLES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
23	ULCFLUSHES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
24	ULCFLUSHFULL	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
25	ULCMBWRITTEN	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
26	PAGESREAD	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
27	PAGESWRITTEN	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
28	PHYSICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
29	PHYSICALWRITES	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
30	LOGICALREADS	☐	SYBBIGINT		DEC	22	0	SYB: Big Integer
31	STARTDATE	☐			STRG	0	0
32	SNAPSHOT_TIMESTAMP	☐	DB6TSTAMP		CHAR	14	0	DB6: Timestamp (Format: YYYYMMDDHHMMSS)
33	TIMESTAMP_FROM	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
34	TIMESTAMP_TO	☐	DBAFTTSTAMP		STRG	0	0	DBA Formatted Timestamp
35	TIME_PERIOD	☐			INT4	10	0
36	SOURCE_HOSTNAME	☐	SYBHOSTNAME	SYBHOSTNAME	CHAR	128	0	SYB: Hostname

History

Last changed by/on	SAP	20140117
SAP Release Created in	732