SAP ABAP Table MSQ_PACCES (Contains data from sysperfinfo on accesses physical&logical)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSQ_PACCES	Table Relationship Diagram
Short Description	Contains data from sysperfinfo on accesses physical&logical

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	FULLSCANS	☐	MSQPAFULLS	INT4	INT4	10	0	Number of unrestricted base table or index scans
2	INDEXSRCH	☐	MSQPAIDXSR	INT4	INT4	10	0	Number of index searches.
3	EXTALLOCS	☐	MSQPAEXAL	INT4	INT4	10	0	Number of extents allocated to database objects
4	EXTDEALLS	☐	MSQPAEXDE	INT4	INT4	10	0	Number of extents deallocated in a database
5	PAGEALLOCS	☐	MSQPAPGAL	INT4	INT4	10	0	Number of pages allocated to database objects
6	PAGEDEALLS	☐	MSQPAPGDE	INT4	INT4	10	0	Number of pages deallocated in a database
7	PAGESPLITS	☐	MSQPAPGSPL	INT4	INT4	10	0	Number of index page splits in a database
8	PROBESCANS	☐	MSQPAPRBSN	INT4	INT4	10	0	Number of probe scans in a database
9	RANGESCANS	☐	MSQPARNGSN	INT4	INT4	10	0	Number of range scans through indexes
10	WORKFILES	☐	MSQPAWFCRE	INT4	INT4	10	0	Number of work files created
11	WORKTABLES	☐	MSQPAWTCRE	INT4	INT4	10	0	Number of work tables created
12	LAZYWRITES	☐	MSQPBLZWTS	INT4	INT4	10	0	Number of buffers written by the lazy writer
13	PAGEREADS	☐	MSQPBPGRDS	INT4	INT4	10	0	Number of physical page reads
14	PAGEWRITES	☐	MSQPBPGWRT	INT4	INT4	10	0	Number of physical page writes
15	REQBUFFPG	☐	MSQPBUFREQ	INT4	INT4	10	0	Number of requests for buffer pages.
16	READAHEAD	☐	MSQPBRAPGS	INT4	INT4	10	0	Number of requests to prefetch pages.
17	AUTOPARAM	☐	MSQPSAUTO	INT4	INT4	10	0	Number of auto-parameterization attempts
18	SQLBATCHS	☐	MSQPSBATCH	INT4	INT4	10	0	Number of Transact-SQL batches received.
19	SQLCOMPILE	☐	MSQPSQLCMP	INT4	INT4	10	0	Number of SQL compilations.
20	AVGLTCHWT	☐	MSQPSALTWT	INT4	INT4	10	0	Average latch wait time in ms for latch requests that wait
21	LATCHWAITS	☐	MSQPSLTHWT	INT4	INT4	10	0	Number of latch requests per second that weren't satisfied

History

Last changed by/on	SAP	20110908
SAP Release Created in