Table/Structure Field list used by SAP ABAP Function Module GET_SQLPERFACCESS_MSS (Retrieve data from the counter objects: ACCESS, BUFFER, and SQL Statistics)
SAP ABAP Function Module 
GET_SQLPERFACCESS_MSS (Retrieve data from the counter objects: ACCESS, BUFFER, and SQL Statistics) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
DBCON - CON_NAME | Logical name for a database connection | SOURCE VALUE(CON_NAME) TYPE DBCON-CON_NAME DEFAULT 'DEFAULT' |
| 2 | Table/Structure Field |
DBCON - CON_NAME | Logical name for a database connection | |
| 3 | Table/Structure Field |
MSQ_PERSEC - READAHEAD | Per second SQL Server performance counter (or %). | |
| 4 | Table/Structure Field |
MSQ_PERSEC - WORKTABLES | Per second SQL Server performance counter (or %). | |
| 5 | Table/Structure Field |
MSQ_PERSEC - WORKFILES | Per second SQL Server performance counter (or %). | |
| 6 | Table/Structure Field |
MSQ_PERSEC - SQLCOMPILE | Per second SQL Server performance counter (or %). | |
| 7 | Table/Structure Field |
MSQ_PERSEC - SQLBATCHS | Per second SQL Server performance counter (or %). | |
| 8 | Table/Structure Field |
MSQ_PERSEC - REQBUFFPG | Per second SQL Server performance counter (or %). | |
| 9 | Table/Structure Field |
MSQ_PERSEC - RANGESCANS | Per second SQL Server performance counter (or %). | |
| 10 | Table/Structure Field |
MSQ_PERSEC - PROBESCANS | Per second SQL Server performance counter (or %). | |
| 11 | Table/Structure Field |
MSQ_PERSEC - PAGEWRITES | Per second SQL Server performance counter (or %). | |
| 12 | Table/Structure Field |
MSQ_PERSEC - PAGESPLITS | Per second SQL Server performance counter (or %). | |
| 13 | Table/Structure Field |
MSQ_PERSEC - PAGEDEALLS | Per second SQL Server performance counter (or %). | |
| 14 | Table/Structure Field |
MSQ_PERSEC - PAGEALLOCS | Per second SQL Server performance counter (or %). | |
| 15 | Table/Structure Field |
MSQ_PERSEC - LAZYWRITES | Per second SQL Server performance counter (or %). | |
| 16 | Table/Structure Field |
MSQ_PERSEC - LATCHWAITS | Per second SQL Server performance counter (or %). | |
| 17 | Table/Structure Field |
MSQ_PERSEC - PAGEREADS | Per second SQL Server performance counter (or %). | |
| 18 | Table/Structure Field |
MSQ_PERSEC - INDEXSRCH | Per second SQL Server performance counter (or %). | |
| 19 | Table/Structure Field |
MSQ_PERSEC - FULLSCANS | Per second SQL Server performance counter (or %). | |
| 20 | Table/Structure Field |
MSQ_PERSEC - EXTDEALLS | Per second SQL Server performance counter (or %). | |
| 21 | Table/Structure Field |
MSQ_PERSEC - EXTALLOCS | Per second SQL Server performance counter (or %). | |
| 22 | Table/Structure Field |
MSQ_PERSEC - AVGLTCHWT | Per second SQL Server performance counter (or %). | |
| 23 | Table/Structure Field |
MSQ_PERSEC - AUTOPARAM | Per second SQL Server performance counter (or %). | |
| 24 | Table/Structure Field |
MSS_PACCES - PAGESPLITS | Number of index page splits in a database | |
| 25 | Table/Structure Field |
MSS_PACCES - PAGEWRITES | Number of physical page writes | |
| 26 | Table/Structure Field |
MSS_PACCES - PROBESCANS | Number of probe scans in a database | |
| 27 | Table/Structure Field |
MSS_PACCES - RANGESCANS | Number of range scans through indexes | |
| 28 | Table/Structure Field |
MSS_PACCES - READAHEAD | Number of pages read in anticipation of use. | |
| 29 | Table/Structure Field |
MSS_PACCES - REQBUFFPG | Number of requests to find a page in the buffer pool. | |
| 30 | Table/Structure Field |
MSS_PACCES - SQLBATCHS | Number of SQL batch requests received by server. | |
| 31 | Table/Structure Field |
MSS_PACCES - SQLCOMPILE | Number of SQL compilations | |
| 32 | Table/Structure Field |
MSS_PACCES - WORKFILES | Number of work files created | |
| 33 | Table/Structure Field |
MSS_PACCES - WORKTABLES | Number of work tables created | |
| 34 | Table/Structure Field |
MSS_PACCES - EXTALLOCS | Number of extents allocated to database objects | |
| 35 | Table/Structure Field |
MSS_PACCES - PAGEDEALLS | Number of pages deallocated in a database | |
| 36 | Table/Structure Field |
MSS_PACCES - AUTOPARAM | Number of auto-parameterization attempts | |
| 37 | Table/Structure Field |
MSS_PACCES - AVGLTCHWT | Average wait time in ms for latch requests that waited. | |
| 38 | Table/Structure Field |
MSS_PACCES - EXTDEALLS | Number of extents deallocated in a database | |
| 39 | Table/Structure Field |
MSS_PACCES - FULLSCANS | Number of unrestricted base table or index scans | |
| 40 | Table/Structure Field |
MSS_PACCES - INDEXSRCH | Number of index searches | |
| 41 | Table/Structure Field |
MSS_PACCES - LATCHWAITS | Number of latch requests that had to wait before granted. | |
| 42 | Table/Structure Field |
MSS_PACCES - LAZYWRITES | Number of pages written by the lazy writer to disk. | |
| 43 | Table/Structure Field |
MSS_PACCES - PAGEALLOCS | Number of pages allocated to database objects | |
| 44 | Table/Structure Field |
MSS_PACCES - PAGEREADS | Number of physical page reads | |
| 45 | Table/Structure Field |
SYST - MSGID | ABAP System Field: Message ID | |
| 46 | Table/Structure Field |
SYST - MSGNO | ABAP System Field: Message Number | |
| 47 | Table/Structure Field |
SYST - MSGTY | ABAP System Field: Message Type | |
| 48 | Table/Structure Field |
SYST - MSGV1 | ABAP System Field: Message Variable | |
| 49 | Table/Structure Field |
SYST - MSGV2 | ABAP System Field: Message Variable | |
| 50 | Table/Structure Field |
SYST - MSGV3 | ABAP System Field: Message Variable | |
| 51 | Table/Structure Field |
SYST - MSGV4 | ABAP System Field: Message Variable |
